[FIXED] Store millisecond value using hibernate @CreationTimestamp annotation

Issue

I am using the following code in my entity

@CreationTimestamp
private LocalDateTime responseDateTime;

This is working fine, however is storing the date in format 2021-02-15 21:26:39. How can I get this date to store with a millisecond value?

Thanks

Solution

I think that issue is mostly related to the actual type of column in your database. Looks like it would be better to use DATETIME(3) type - as it allows to have fractional second information.
More information can be found at MySQL Reference Manual

Answered By - Daniel
Answer Checked By - Candace Johnson (JavaFixing Volunteer)