SimpleDateFormat question 1

[advait75]

Hi,
I have a string like "01-Feb-2004". I need to get it into a 2004-02-01 format so that I can insert into a MYSQL db.
I tried using the SimpleDateFormat, but I get an error saying - Unparseable format.
This is my code-
String todate=request.getParameter("todate");
SimpleDateFormat df = new SimpleDateFormat("yyyy-MM-dd");
df.setLenient( false );
java.util.Date tDate=null;
tDate = df.parse(todate);

Can someone please help.
Thanks.

 

[sedj]

Almost there, but you need "MMM", rather than "MM" to parse the first string.
Read the docs : they have some example formats :

http://java.sun.com/j2se/1.4.2/docs/api/java/text/SimpleDateFormat.html

String todate= "2000-Feb-01";
SimpleDateFormat df = new SimpleDateFormat("yyyy-MMM-dd");
df.setLenient( false );
java.util.Date tDate=null;
tDate = df.parse(todate);
System.out.println(tDate);
df = new SimpleDateFormat("yyyy-MM-dd");
String newdatestring = df.format(tDate);
System.out.println(newdatestring);

--------------------------------------------------
Free Java/J2EE Database Connection Pooling Software

http://www.primrose.org.uk

 

[Diancecht]

Shouldn't it be "dd-MMM-yyyy"?

Cheers,
Dian

 

[sedj]

lol, yeah, for the first format, not the second though.

--------------------------------------------------
Free Java/J2EE Database Connection Pooling Software

http://www.primrose.org.uk