Search code examples
javamysqldate

java string date conversion

I want to convert a string to date before storing it and I used 

SimpleDateFormat format = new SimpleDateFormat("yyyy-mm-dd");
Date returnDate = format.parse(date);

When I ran this with sample date: the input string for date conversion is 2014-05-06 the parsed date is Mon Jan 06 00:05:00 IST 2014

now when I store the returnDate in MySql the value is 2014-01-06 00:05:00

Why is the date changed ? Want to know if I am missing something. I went through the posts related to date string conversion : How to convert a date from a Datepicker to Mysql DATETIME format using java?

Solution

  • In your DateFormat use MM for month instead of mm, that is for minutes

    Reference: http://docs.oracle.com/javase/6/docs/api/java/text/SimpleDateFormat.html