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

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

Post by sh » Sat, 03 Mar 2007 23:30:31



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
 
 
 

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

Post by www » Sun, 04 Mar 2007 01:15:11


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.