Java String to Date Conversion Issue

Question

I searched this issue but found only changing from String to Date and then displaying Date to String. I have a requirement, where I receive Date in String format and then I have to parse that in Date object and enter in Database.But whenever I convert String to Date it gives me wrong output. Please suggest. thanks in advance.

String subscribedDate="2012-09-28 11:00:00";
String oldFormat = "yyyy-mm-dd hh:mm:ss";
SimpleDateFormat sdf1 = new SimpleDateFormat(oldFormat);
Date dates=sdf1.parse(subscribedDate);
System.out.println(dates);
//code for entering dates in database.

Output: Sat Jan 28 00:09:00 GMT 2012 (Which is incorrect!!). I want as 2012-09-28 11:00:00

MadProgrammer · Accepted Answer · 2012-10-02 11:16:42Z

6

Your format string is wrong. yyyy-mm-dd hh:mm:ss is basically saying "years-miniutes-days hours:minutes:seconds" which I'm pretty sure you don't want.

You want

String oldFormat = "yyyy-MM-dd hh:mm:ss";

Have a look at the SimpleDateFormat docs for more info

answered Oct 2, 2012 at 11:16

MadProgrammer

348k22 gold badges243 silver badges379 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Vikdor · Accepted Answer · 2012-10-02 11:17:01Z

3

Firstly, the month field is represented using MM and not mm which is for minutes.

Secondly, the formatter can be used to print the date in the desired format.

String subscribedDate="2012-09-28 11:00:00";
String oldFormat = "yyyy-MM-dd hh:mm:ss";
SimpleDateFormat sdf1 = new SimpleDateFormat(oldFormat);
Date dates=sdf1.parse(subscribedDate);
System.out.println(sdf1.format(dates));
// code for entering dates in database.

answered Oct 2, 2012 at 11:17

Vikdor

24.2k10 gold badges66 silver badges86 bronze badges

Comments

Joseph Mansfield · Accepted Answer · 2012-10-02 22:15:03Z

1

I suppose the oldFormat variable in the second line should be

oldFormat = "yyyy-MM-dd HH:mm:ss"; // hours counted 0~23

or

oldFormat = "yyyy-MM-dd hh:mm:ss"; // hours counted 0~11

edited Oct 2, 2012 at 22:15

Joseph Mansfield

111k22 gold badges249 silver badges329 bronze badges

answered Oct 2, 2012 at 11:20

Zie Iuk

383 bronze badges

Comments

Alex · Accepted Answer · 2012-10-02 11:16:00Z

1

Try to change oldFormat to

String oldFormat = "yyyy-MM-dd hh:mm:ss";

where MM are capital letters.

answered Oct 2, 2012 at 11:16

Alex

11.6k7 gold badges39 silver badges52 bronze badges

Comments

Tim Lamballais · Accepted Answer · 2012-10-02 11:16:30Z

0

Try this:

        String oldFormat = "yyyy-MM-dd hh:mm:ss";

See the docs to find out why.

answered Oct 2, 2012 at 11:16

Tim Lamballais

1,0445 silver badges10 bronze badges

Collectives™ on Stack Overflow

Java String to Date Conversion Issue

5 Answers 5

Comments

Comments

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

Comments

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related