Error parsing datetime, DateTimeParseException with valid timestamp

Question

I'm trying to parse a timestamp object from sql and am having problems, heres what I have:

 DateTimeFormatter dateDTF = DateTimeFormatter.ofLocalizedDateTime(FormatStyle.SHORT);


 String start = c.getStartTime().getValue();
 //Start: 2018-12-01 16:00:00
 System.out.println("Start: " + start);
 LocalDateTime startDatetime = LocalDateTime.parse(start, dateDTF);

As you can see in the commented code my with the value of start to trim down my working example.I'm getting the following error:

java.time.format.DateTimeParseException: Text '2018-12-01 16:00:00' could not be parsed at index 4

Nicholas K · Accepted Answer · 2018-11-30 06:13:29Z

2

Use

DateTimeFormatter dtf = DateTimeFormatter.ofPattern("yyyy-MM-dd HH:mm:ss");

Here you specify the pattern of the DateTimeFormat

answered Nov 30, 2018 at 6:13

Nicholas K

15.4k8 gold badges35 silver badges59 bronze badges

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

2 Comments

Joe Over a year ago

I seriously hate that there's no proper wrapper for the SQL timestamp and I have to manually do this garbage. That being said thanks for the help! I'll accept it as soon as I can.

Anonymous Over a year ago

@Joe You shouldn’t fetch timestamp values as strings from your database. Depending on what your JDBC driver offers, see if you can fetch an Instant, an OffsetDateTime or a LocalDateTime. Use for example yourResultSet.getObject(6, Instant.class).

Collectives™ on Stack Overflow

Error parsing datetime, DateTimeParseException with valid timestamp

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related