Parsing Custom Date String to MySql Date String in Java

Question

I have a 'Fri Jan 16 08:41:11 GMT 2015' datetime string in my database.

I would like to parse it as a mysql datetime format String.

I am trying the code below, but getting

java.text.ParseException: Unparseable date: "Fri Jan 16 08:41:11 GMT 2015".

Code is:

String date = null;
if(pos.get("utc") != null) {
    try {
        SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss"); 
        Date parsed = sdf.parse("Fri Jan 16 08:41:11 GMT 2015");
        date = sdf.format(parsed);
    } catch (JSONException | ParseException e) {
        e.printStackTrace();
    }
}

Any suggestions would be appreciated.

Look at your DateFormat pattern. Does it match your date String? — Reimeus
– Reimeus, Commented Jan 19, 2015 at 10:39

Sivakumar · Accepted Answer · 2015-01-19 10:47:18Z

1

Try this SimpleDateFormat sdf = new SimpleDateFormat("E MMM dd HH:mm:ss z yyyy"); Reference

answered Jan 19, 2015 at 10:47

Sivakumar

1,77114 silver badges19 bronze badges

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

Comments

hawx · Accepted Answer · 2015-01-19 10:49:24Z

0

Thanks for the help :-)

String date = null;
if(pos.get("utc") != null) {
    try {
        SimpleDateFormat sdf = new SimpleDateFormat("EEE MMM dd HH:mm:ss z yyyy");
        Date parsed = sdf.parse("Fri Jan 16 08:41:11 GMT 2015");
        date = sdf.format(parsed);
    } catch (JSONException | ParseException e) {
        e.printStackTrace();
    }
}

answered Jan 19, 2015 at 10:49

hawx

1,6895 gold badges21 silver badges38 bronze badges

Collectives™ on Stack Overflow

Parsing Custom Date String to MySql Date String in Java

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related