asked on Save date without time
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
cheers
Zolf
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);
}
}
cheers
Zolf
JavaJava EEJSP
Last Comment
Zolf
SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
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>
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?
ASKER
I am using hibernate to create the tables for me in the database
SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
thanks for your comment.
can you please elaborate on this
can you please elaborate on this
It still might be better simply to truncate or ingore time info though
It's better to have too much information (which is discardable - just don't manifest it in the presentation layer) than not enough
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)?
ASKER
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();
}
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();
}
SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
Change the datatype of your column in database to DATEWhy would you want to lose information for a negligible saving in storage?
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
Kindly go through the question once again.I don't need to ;)
ASKER
Thanks
I am using Microsoft SQL Server 2008