Unable to parser MYSQL timestamp using SimpleDateFormat in Android

Question

I am using the following to parse a string to date. However I get an Unparseable date exception. This is the code

String dateString="2018-09-20T11:44:48.000Z";//MYSQL timestamp from server
SimpleDateFormat dateFormat = new SimpleDateFormat("MM/dd/yyyy'T'HH:mm:ss.S'Z'");
Date convertedDate = new Date();
try {
  convertedDate = dateFormat.parse(dateString); //error here
  textTime.setReferenceTime(convertedDate.getTime());
} catch (ParseException e) {
  e.printStackTrace();
}

(1) Don’t get a string from MySQL, get an Instant, LocalDateTime or Timestamp, whichever works. (2) Consider avoiding the SimpleDateFormat class, it’s long outdated and notoriously troublesome. If java.time, the modern Java date and time API, isn’t built into your Android version, consider the ThreeTenABP library, the backport of java.time for Android. — Anonymous
– Anonymous, Commented Sep 20, 2018 at 14:20
Also don’t parse the Z in the date string as a literal (in single quotes). It’s a UTC offset and needs to be parsed as such. Otherwise SimpleDateFormat will use the JVM’s time zone, leading to an incorrect point in time. — Anonymous
– Anonymous, Commented Sep 21, 2018 at 7:19

IntelliJ Amiya · Accepted Answer · 2018-09-20 13:06:27Z

2

You should rectify your SimpleDateFormat.

   String dateString="2018-09-20T11:44:48.000Z";

   SimpleDateFormat inputFormat     = new SimpleDateFormat("yyyy-MM-dd'T'HH:mm:ss.S'Z'");
   SimpleDateFormat outputFormat    = new SimpleDateFormat("MM/dd/yyyy'T'HH:mm:ss.S'Z'");

    Date   convertedDate    = null;
    String strOP            = null;

    try 
    {
        convertedDate = inputFormat.parse(dateString);
        strOP         = outputFormat.format(convertedDate);
        textTime.setReferenceTime(strOP);
    } 
    catch (ParseException e) 
    {
        e.printStackTrace();
    }

edited Sep 20, 2018 at 13:06

answered Sep 20, 2018 at 12:46

IntelliJ Amiya

75.8k15 gold badges170 silver badges199 bronze badges

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

Collectives™ on Stack Overflow

Unable to parser MYSQL timestamp using SimpleDateFormat in Android

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related