Convert MM/dd/yyyy hh:mm a format to milliseconds

Question

I am trying to Convert date and time i am receiving in MM/dd/yyyy hh:mm a format to milliseconds so that i can push the date as end date in google calendar. I am trying below code but i am getting error.

Code:

String myDate = "10/20/2017 8:10 AM";
SimpleDateFormat sdf = new SimpleDateFormat("MM/dd/yyyy hh:mm a");
Date date = sdf.parse(myDate);
long millis = date.getTime();

Error:

java.text.ParseException: Unparseable date: "10/20/2017 8:10 AM" (at offset 16)

I think the given value of your myDate is not exactly to your Date Formatter. try to change your myDate to "10/20/2017 08:10 AM" Since you're using a `hh` [SimpleDateFormat](https://developer.android.com/reference/java/text/SimpleDateFormat.html) — dotGitignore, Oct 13 '17 at 14:28
@Jerrol i tried what you suggested but still getting the same error. — Ironman, Oct 13 '17 at 14:38
The code you have posted works correctly https://i.imgur.com/S22RkVs.png . Are you getting this error when you run that exact code? — Stephen, Oct 13 '17 at 14:39
@Stephen can you please tell me whether the number i am getting is too long ? — Ironman, Oct 13 '17 at 14:53
@Ironman yea you and either my code is working. https://imgur.com/a/66aAP — dotGitignore, Oct 13 '17 at 14:57
@Ironman, It is not too long. A Java long is 8 bytes which is enough to store your milliseconds. Can you show your import statements? — Stephen, Oct 13 '17 at 15:00
@Stephen please find my import statements in this link https://imgur.com/a/I0Wtc — Ironman, Oct 13 '17 at 15:07

KeLiuyue · Accepted Answer · 2017-10-13T15:17:56.860

3

Try this .

String myDate = "10/20/2017 8:10 AM";
SimpleDateFormat sdf = new SimpleDateFormat("MM/dd/yyyy h:mm a", Locale.ENGLISH);
Date date = sdf.parse(myDate);
long millis = date.getTime();

Add Locale.ENGLISH in your code .

edited Oct 13 '17 at 15:17

answered Oct 13 '17 at 14:34

KeLiuyue

8,149
4
25
42

You can try again. – KeLiuyue Oct 13 '17 at 14:40
Still same issue i am getting. – Ironman Oct 13 '17 at 14:43
can you please tell me whether the number i am getting is too long ? – Ironman Oct 13 '17 at 14:53
You can try it again. – KeLiuyue Oct 13 '17 at 15:18

score 0 · Answer 2 · answered Oct 13 '17 at 15:35

Your code seems to be OK, i've just added try/catch block:

try {
    String myDate = "10/20/2017 8:10 AM";
    SimpleDateFormat sdf = new SimpleDateFormat("MM/dd/yyyy hh:mm a");
    Date date = sdf.parse(myDate);
    long millis = date.getTime();

    System.out.println(date);
    System.out.println(millis);
    }
    catch(Exception ex) {
        System.out.println(ex);
    }

This code prints 1508479800000 as millis. If you want to check it backwards try this:

String x = "1508479800000";

            DateFormat formatter = new SimpleDateFormat("MM/dd/yyyy hh:mm a");

            long milliSeconds= Long.parseLong(x);
            System.out.println(milliSeconds);

            Calendar calendar = Calendar.getInstance();
            calendar.setTimeInMillis(milliSeconds);
            System.out.println(formatter.format(calendar.getTime()));

this will give you 10/20/2017 08:10 AM.

score -1 · Answer 3 · answered Oct 13 '17 at 14:23

You can use SimpleDateFormat to do it. You just have to know 2 things.

All dates are internally represented in UTC .getTime() returns the number of milliseconds since 1970-01-01 00:00:00 UTC. package se.wederbrand.milliseconds;

import java.text.SimpleDateFormat;
import java.util.Date;
import java.util.TimeZone;

public class Main {        
    public static void main(String[] args) throws Exception {
        SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss.SSS");
        sdf.setTimeZone(TimeZone.getTimeZone("UTC"));

        String inputString = "00:01:30.500";

        Date date = sdf.parse("1970-01-01 " + inputString);
        System.out.println("in milliseconds: " + date.getTime());        
    }
}

by this one https://stackoverflow.com/a/8826392/8456432

i am already using `SimpleDateFormat`. Please check my input value. — Ironman, Oct 13 '17 at 14:36

Convert MM/dd/yyyy hh:mm a format to milliseconds

3 Answers3