Solved

Save date without time

Posted on 2014-01-13
15
493 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 83

Assisted Solution

by:Dave Baldwin
Dave Baldwin earned 100 total points
ID: 39775922
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
ID: 39775930
thanks for your feedback.

I am using Microsoft SQL Server 2008
0
 

Author Comment

by:zolf
ID: 39775937
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
Master Your Team's Linux and Cloud Stack!

The average business loses $13.5M per year to ineffective training (per 1,000 employees). Keep ahead of the competition and combine in-person quality with online cost and flexibility by training with Linux Academy.

 
LVL 83

Expert Comment

by:Dave Baldwin
ID: 39775948
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
ID: 39775991
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
ID: 39776157
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
ID: 39776186
thanks for your comment.

can you please elaborate on this
It still might be better simply to truncate or ingore time info though
0
 
LVL 86

Expert Comment

by:CEHJ
ID: 39776229
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 32

Expert Comment

by:awking00
ID: 39777535
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
ID: 39778366
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
ID: 39784949
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
ID: 39785058
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
ID: 39785082
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
ID: 39785112
Kindly go through the question once again.
I don't need to ;)
0
 

Author Closing Comment

by:zolf
ID: 39787633
Thanks
0

Featured Post

Master Your Team's Linux and Cloud Stack!

The average business loses $13.5M per year to ineffective training (per 1,000 employees). Keep ahead of the competition and combine in-person quality with online cost and flexibility by training with Linux Academy.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
even odd program using while loop 3 43
use lov values 2 50
hibernate example for saving data 19 43
null output 3 25
Introduction Java can be integrated with native programs using an interface called JNI(Java Native Interface). Native programs are programs which can directly run on the processor. JNI is simply a naming and calling convention so that the JVM (Java…
Java Flight Recorder and Java Mission Control together create a complete tool chain to continuously collect low level and detailed runtime information enabling after-the-fact incident analysis. Java Flight Recorder is a profiling and event collectio…
Viewers learn about the “while” loop and how to utilize it correctly in Java. Additionally, viewers begin exploring how to include conditional statements within a while loop and avoid an endless loop. Define While Loop: Basic Example: Explanatio…
Viewers learn about the “for” loop and how it works in Java. By comparing it to the while loop learned before, viewers can make the transition easily. You will learn about the formatting of the for loop as we write a program that prints even numbers…

832 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