how to convert yyyy-MM-dd HH:mm:ss to java.sql.Date

Thread view:

sh - 02 Mar 2007 14:30 GMT

hi,

how to convert date in this format yyyy-MM-dd HH:mm:ss to
java.sql.Date

if i use directly like this java.sql.Date.valueOf(processDate)

am getting exception java.lang.NumberFormatException: For input
string: "02 19:51:51"

if anybody knows reply back immedietely.

thanks in advance

Reply to this Message

www - 02 Mar 2007 16:15 GMT

> hi,
>
[quoted text clipped - 5 lines]
> am getting exception java.lang.NumberFormatException: For input
> string: "02 19:51:51"

SimpleDateFormat myFormat = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
Date myDate = new Date(myFormat.parse(your_time_string).getTime());
//need try-catch block

BWY, why you input "02 19:51:51"? It should be "2002-xx-xx 19:51:51",
based on your SimpleDateFormat.

Reply to this Message

Free Magazines

Get these publications absolutely FREE for up to 12 months. There are no hidden fees and no obligation. Simply choose a title, complete the application form and submit it. Read more ...