Converting java.util.Date to java.sql.Date

M

mail4sushovan

Hello Friends
In my program i am using the following codes:

Date today = new Date();
log.debug("today is"+today);
SimpleDateFormat fmt = new SimpleDateFormat("yyyy-mm-dd");
String todayStr = fmt.format(today);
log.debug("todayStr value"+todayStr);
java.sql.Date dt = java.sql.Date.valueOf(new String(todayStr));
log.debug("current Dt is:"+dt);

The output iam getting is like this:
today is Sat Sep 09 19:20:13 IST 2006(from java.util.Date)
todayStr value 2006-20-09(from string value)
current Dt is: 2007-08-09(from java.sql.Date)


So how to avoid this.Please help me
Thank You in advance
sushovan
 
T

Thomas Fritsch

In my program i am using the following codes:

Date today = new Date();
log.debug("today is"+today);
SimpleDateFormat fmt = new SimpleDateFormat("yyyy-mm-dd");
String todayStr = fmt.format(today);
log.debug("todayStr value"+todayStr);
java.sql.Date dt = java.sql.Date.valueOf(new String(todayStr));
log.debug("current Dt is:"+dt);

The output iam getting is like this:
today is Sat Sep 09 19:20:13 IST 2006(from java.util.Date)
todayStr value 2006-20-09(from string value)
current Dt is: 2007-08-09(from java.sql.Date)


So how to avoid this.Please help me

java.util.Date today = new java.util.Date();
long t = today.getTime();
java.sql.Date dt = new java.sql.Date(t);

See also the API doc of java.sql.Date, especially its constructor.
 
F

Frank Langelage

Hello Friends
In my program i am using the following codes:

Date today = new Date();
log.debug("today is"+today);
SimpleDateFormat fmt = new SimpleDateFormat("yyyy-mm-dd");
String todayStr = fmt.format(today);
log.debug("todayStr value"+todayStr);
java.sql.Date dt = java.sql.Date.valueOf(new String(todayStr));
log.debug("current Dt is:"+dt);

The output iam getting is like this:
today is Sat Sep 09 19:20:13 IST 2006(from java.util.Date)
todayStr value 2006-20-09(from string value)
current Dt is: 2007-08-09(from java.sql.Date)

As shown by Thomas there is an easier and better way to get an
java.sql.Date from java.util.Date.

In your code example you used the wrong date format: 'mm' stands for the
minutes of the time part, 'MM' is the format for the month of the date.
 
Joined
Dec 9, 2008
Messages
1
Reaction score
0
I have small problem in program
how to convert
java.sql.Date date = new java.sql.Date(today.getTime());
to Normal String
any one help me pls in this problem
 
Joined
May 4, 2011
Messages
1
Reaction score
0
I have small problem in program
how to convert
java.sql.Date date = new java.sql.Date(today.getTime());
to Normal String
any one help me pls in this problem

String datestr001 = (new java.sql.Date(today.getTime())).toString();


The corrected one should be:-

Date today = new Date();
log.debug("today is"+today);
SimpleDateFormat fmt = new SimpleDateFormat("yyyy-MM-dd");
String todayStr = fmt.format(today);
log.debug("todayStr value"+todayStr);
java.sql.Date dt = java.sql.Date.valueOf(new String(todayStr));
log.debug("current Dt is:"+dt);

The output is:-
todayStr=dt
 
Joined
May 4, 2011
Messages
4
Reaction score
0
Hi everyone, I newbie and I very happy join in forum.
grey.png

I hope can be friends with you all members, Thanks.
I like it this thread.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Members online

Forum statistics

Threads
473,731
Messages
2,569,432
Members
44,832
Latest member
GlennSmall

Latest Threads

Top