How to convert a String AM/PM date to Timestamp in Java?

Question

I want to parse a date that includes AM/PM format from String to Timestamp.

Although when I try to parse this date: Dec 31 2017 12:00AM

I get a

Exception in thread "main" java.text.ParseException: Unparseable date: "Dec 31 2017 12:00AM"
    at java.text.DateFormat.parse(Unknown Source)
    at test.DatteTest.main(DatteTest.java:16)

My code:

String endDate = "Dec 31 2017 12:00AM";         
SimpleDateFormat dateFormat = new SimpleDateFormat("MMM dd yyyy hh:mmaa");
Date parsedDate = dateFormat.parse(endDate);
Timestamp timestamp = new Timestamp(parsedDate.getTime());
System.out.println(endDate);
System.out.println(timestamp);

Am I doing something wrong in the simpledateformat? "MMM dd yyyy hh:mmaa"?

for starts stop using `SimpleDateFormat`... and are you sure about the error? works just fine for me — Eugene, May 23 '19 at 08:51
My company's program is using java SE7.. not my choice.. @Eugene — Ioanna Katsanou, May 23 '19 at 08:53
@Eugene this same code does not work for me. It throws an exception. — Ioanna Katsanou, May 23 '19 at 08:56
new SimpleDateFormat("MMM dd yyyy hh:mmaa", Locale.ENGLISH); — George Z., May 23 '19 at 08:57
There's a [backport](https://www.threeten.org/threetenbp/apidocs/) of the JSR-310 types for Java 7. — cassiomolin, May 23 '19 at 08:58
@GeorgeZ. this worked !! If you want post your answer so I can mark it as best answer — Ioanna Katsanou, May 23 '19 at 08:59
As an aside consider throwing away the long outmoded and notoriously troublesome `SimpleDateFormat` and friends, and adding [ThreeTen Backport](https://www.threeten.org/threetenbp/) to your project in order to use `java.time`, the modern Java date and time API. It is so much nicer to work with. — Ole V.V., May 23 '19 at 09:21

score 2 · Accepted Answer · answered May 23 '19 at 08:59

2

The input date contains a word in english. You have to give the locale :

SimpleDateFormat dateFormat = new SimpleDateFormat("MMM dd yyyy hh:mmaa", Locale.ENGLISH);

answered May 23 '19 at 08:59

Arnaud Denoyelle

29,980
16
92
148

How to convert a String AM/PM date to Timestamp in Java?

1 Answers1