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

Thread view:

mail4sushovan@gmail.com - 09 Sep 2006 15:43 GMT

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

Reply to this Message

Thomas Fritsch - 09 Sep 2006 16:27 GMT

> In my program i am using the following codes:
>
[quoted text clipped - 12 lines]
>
> 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.

Signature

Thomas

Reply to this Message

Frank Langelage - 09 Sep 2006 19:04 GMT

> Hello Friends
> In my program i am using the following codes:
[quoted text clipped - 11 lines]
> 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.

Reply to this Message

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

Free Magazines