java string date conversion

Question

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?

possible duplicate of Convert date from string "yyyyddmm hh:mm:ss" to String "DD/MM/YYYY" in JAVA — Elliott Frisch
– Elliott Frisch, Commented May 7, 2014 at 5:12

Juned Ahsan · Accepted Answer · 2014-05-07 04:52:27Z

6

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

answered May 7, 2014 at 4:52

Juned Ahsan

68.9k12 gold badges101 silver badges138 bronze badges

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

Comments

Basil Bourque · Accepted Answer · 2025-01-09 06:48:30Z

2

java.time

Use only the modern java.time classes for your date-time handling. Never use the terribly-flawed legacy classes such as Date, Calendar, SimpleDateFormat, etc.

`LocalDate`

For a date-only value, without time-of-day, and without time zone, use java.time.LocalDate class.

ISO 8601

Your input string of YYYY-MM-DD complies with the ISO 8601 standard for date-time formats.

The java.time classes use the standard formats by default when parsing/generating text. So no need to specify a formatting pattern. The LocalDate class can parse directly.

LocalDate ld = LocalDate.parse ( "2014-05-06" ) ;

Generate the same standard text.

String output = ld.toString() ;

answered Jan 9 at 6:48

Basil Bourque

347k130 gold badges950 silver badges1.3k bronze badges

1 Comment

Arvind Kumar Avinash Jan 10 at 11:35

The OP has used the wrong symbol, m instead of M. I suggest you add a note about this problem to your answer. Also, since Java has different meanings of Y vs. y and D vs. d, I would avoid using Y and D where y and d is meant even when I point to a resource (e.g. ISO 8601) that uses the generic symbol. For learners: As this answer suggests, new code should use java.time API instead of the error-prone legacy java.util date-time API.

user3500580 · Accepted Answer · 2014-05-07 04:58:47Z

0

You can use like this :

Date mDate= new Date(System.currentTimeMillis());
        SimpleDateFormat mDateFormat= new SimpleDateFormat("dd MMM yyyy HH:mm a");
        String dateformat=mDateFormat.format(mDate);


the string ["dd MMM yyyy HH:mm a"]  can be changed according to need of formate.

Like in your case : "yyyy-mm-dd

answered May 7, 2014 at 4:58

user3500580

13 bronze badges

Collectives™ on Stack Overflow

java string date conversion

3 Answers 3

Comments

java.time

`LocalDate`

ISO 8601

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

java.time

LocalDate

ISO 8601

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related

`LocalDate`