How to retrieve time in hh:mm:ss format from Time stamp in Java

Question

I have an issue related to retrieving time from time stamp. Below is the code, I get the timestamp from gui, which I need to convert into hh:mm:ss and insert into database.

LocalDate timestamp = LocalDate.parse(getOfferingLetter().getCreatedTimeStamp(),DateTimeFormatter.ofPattern("yyyy-MM-dd HH:mm:ss.SSSSSS"));
Timestamp.valueOf(timestamp.atStartOfDay();

The above code retrieves date like this 2022-04-08 00:00:00.0. I need the time to be retrieved like this 00:00:00, how do I do this without using SimpleDateFormat?

i need only the time to be retrieved in the format "hh:mm:ss" cause thats the format which is accepted by the DB . — Krishna Lakshmi
– Krishna Lakshmi, Commented Apr 11, 2022 at 17:38
Change the pattern in the DateTimeFormatter you are using and must do the work. — Evgeni Enchev
– Evgeni Enchev, Commented Apr 12, 2022 at 7:39
@Shark, I tried SimpleDateFormat and it returned a string , I again converted it to java.sql.Time and tried inserting and I get DataType Mismatch error which is weird , I tried inserting directly with the values formed in the query in java code and they are inserted fine . Not sure why I am unable to insert with Java code. — Krishna Lakshmi
– Krishna Lakshmi, Commented Apr 12, 2022 at 8:30

DharmanBot · Accepted Answer · 2022-04-12 09:14:12Z

0

Well, this will give you the time:

LocalDateTime localDateTime = LocalDateTime.parse("2000-10-10 10:15:33.123456", DateTimeFormatter.ofPattern("yyyy-MM-dd HH:mm:ss.SSSSSS"));
String timeHHmmss = localDateTime.format(DateTimeFormatter.ofPattern("HH:mm:ss"));
LocalTime localTime = LocalTime.parse(timeHHmmss);

But you cannot create Timestamp from LocalTime.

edited Apr 12, 2022 at 9:14

DharmanBot

1,0742 gold badges7 silver badges10 bronze badges

answered Apr 12, 2022 at 9:07

Evgeni Enchev

5523 silver badges10 bronze badges

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

Collectives™ on Stack Overflow

How to retrieve time in hh:mm:ss format from Time stamp in Java

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