Solved

Save date without time

Posted on 2014-01-13
15
489 Views
Last Modified: 2014-01-16
Hello there,

I have this method which converts Persian date to gregoian date and saves in the mssql db. the data is now saved like this in the table col 2014-01-14 00:00:00.
How can I save the date without the time i.e. I just want to save this 2014-01-14

@SuppressWarnings("deprecation")
	public static Date jalaliToGregorian(String nowDate) {
		try{
			GWTPersianCalendar pcal1 = new GWTPersianCalendar();
			pcal1.parsePersianDate(nowDate);
			return new Date(pcal1.getTime());
			
		}
		catch (Exception e) {
			return new Date(nowDate);
		}
		
	}

Open in new window


cheers
Zolf
0
Comment
Question by:zolf
  • 6
  • 4
  • 2
  • +2
15 Comments
 
LVL 82

Assisted Solution

by:Dave Baldwin
Dave Baldwin earned 100 total points
Comment Utility
You would have to make a DATE column.  DATETIME column will always add the 00:00:00.

MySQL or Microsoft SQL Server?
0
 

Author Comment

by:zolf
Comment Utility
thanks for your feedback.

I am using Microsoft SQL Server 2008
0
 

Author Comment

by:zolf
Comment Utility
this is my hibernate hbm file

<property name="mfgDate" type="java.util.Date">
            <column name="mfgDate" />
        </property>
        <property name="expDate" type="java.util.Date">
            <column name="expDate" />
        </property>

Open in new window

0
 
LVL 82

Expert Comment

by:Dave Baldwin
Comment Utility
Here http://technet.microsoft.com/en-us/library/ms186724.aspx are the date and time datatypes available in Microsoft SQL Server.  "hibernate hbm file" means nothing to me and it does not look like it is what defines the columns in an SQL Server Database.  Is it 'your' database so you can have the columns re-defined?
0
 

Author Comment

by:zolf
Comment Utility
I am using hibernate to create the tables for me in the database
0
 
LVL 86

Assisted Solution

by:CEHJ
CEHJ earned 100 total points
Comment Utility
this is my hibernate hbm file
Well if you used java.sql.Date instead, then that doesn't hold time info. It still might be better simply to truncate or ingore time info though
0
 

Author Comment

by:zolf
Comment Utility
thanks for your comment.

can you please elaborate on this
It still might be better simply to truncate or ingore time info though
0
Highfive Gives IT Their Time Back

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

 
LVL 86

Expert Comment

by:CEHJ
Comment Utility
It's better to have too much information (which is discardable - just don't manifest it in the presentation layer) than not enough
0
 
LVL 31

Expert Comment

by:awking00
Comment Utility
It looks like you are using the method getTime() from the GWTPersianCalendar class to return your conversion value. What datatype is that and what other methods might it have (such as getDate)?
0
 

Author Comment

by:zolf
Comment Utility
by: awking00

thanks for your feedback. this is the getTime() method of GWTPersianCalendar class.that is the only method it has.

@Override
    public long getTime() {
        // TODO Remove timeZoneoffset like /*- (getTimezoneOffset()*60000) */
        return super.getTime();
    }
0
 
LVL 1

Assisted Solution

by:Smart_Kid
Smart_Kid earned 300 total points
Comment Utility
Change the datatype of your column in database to DATE  (i preassume, the current datatype will be DATETIME).
0
 
LVL 86

Expert Comment

by:CEHJ
Comment Utility
Change the datatype of your column in database to DATE  
Why would you want to lose information for a negligible saving in storage?
0
 
LVL 1

Accepted Solution

by:
Smart_Kid earned 300 total points
Comment Utility
Changing the datatype was not mentioned not to save any storage space.
But it was a possible suggestion/answer to the question.

The question is that the programmer is not interested in saving the date in database with the time info. As per the question, not even 00:00:00 should not be saved in the database. So the only option for storing just date is to change the datatype of the column.

Kindly go through the question once again.
0
 
LVL 86

Expert Comment

by:CEHJ
Comment Utility
Kindly go through the question once again.
I don't need to ;)
0
 

Author Closing Comment

by:zolf
Comment Utility
Thanks
0

Featured Post

How to improve team productivity

Quip adds documents, spreadsheets, and tasklists to your Slack experience
- Elevate ideas to Quip docs
- Share Quip docs in Slack
- Get notified of changes to your docs
- Available on iOS/Android/Desktop/Web
- Online/Offline

Join & Write a Comment

An old method to applying the Singleton pattern in your Java code is to check if a static instance, defined in the same class that needs to be instantiated once and only once, is null and then create a new instance; otherwise, the pre-existing insta…
Introduction This article is the second of three articles that explain why and how the Experts Exchange QA Team does test automation for our web site. This article covers the basic installation and configuration of the test automation tools used by…
Viewers will learn about the regular for loop in Java and how to use it. Definition: Break the for loop down into 3 parts: Syntax when using for loops: Example using a for loop:
This tutorial covers a practical example of lazy loading technique and early loading technique in a Singleton Design Pattern.

728 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now