String date to SQL date adding years

Question

I am using SimpleDateFormat to convert a date string to java.sql.date.
On converting, I am getting a issue, i.e. Year is getting added automatically.
Code:

String d="2012-12-04T08:48:00";
SimpleDateFormat formatter = new SimpleDateFormat("yyyy-mm-dd'T'HH:MM:SS");
java.util.Date date = null;
date = formatter.parse(d);
System.out.println("UTIL DATE: "+date);
System.out.println("SQL DATE: "+new Date(date.getTime()));

Output:

UTIL DATE:  Fri Dec 04 08:12:00 IST 2015  
SQL DATE:  2015-12-04

I should have got 2012 year in date, but it is adding up 3 years, Is there anything wrong in my code?
Thanks in Advance.

score 2 · Accepted Answer · edited Oct 16 '14 at 11:43

2

mm represents minutes, MM is used to match the months - swap the field patterns

SimpleDateFormat formatter = new SimpleDateFormat("yyyy-MM-dd'T'HH:mm:ss");

edited Oct 16 '14 at 11:43

Seelenvirtuose

20,273
6
37
66

answered Oct 16 '14 at 11:35

Reimeus

158,255
15
216
276

1

Exactly! And the three years come from the month value "48", which is 3*12 months too much (=> 3 years). – Seelenvirtuose Oct 16 '14 at 11:37
There is a misstake in your solution. The time should `:mm:ss` I think – Jens Oct 16 '14 at 11:43
@Reimeus I edited your suggestion as you also misplaced some field patterns (minutes and seconds). – Seelenvirtuose Oct 16 '14 at 11:44

score 1 · Answer 2 · answered Oct 16 '14 at 11:42

1

Change your simple date format as of below code:

SimpleDateFormat formatter = new SimpleDateFormat("yyyy-MM-dd'T'HH:mm:ss");

Here mm is minutes and MM for monts.

answered Oct 16 '14 at 11:42

Imran

429
9
23

String date to SQL date adding years

2 Answers2