fractional second is not being saved in database even though the column type is datetime(6)?

Asked Aug 25 '20 at 09:04

Active Aug 25 '20 at 09:29

Viewed 75 times

I am converting the racestarttime and raceendtime which are epoch time to date as follows.

  Date startDateTime = new Date(raceStartTime.toLong())
  Date endDateTime = new Date(raceEndTime.toLong())

The first two columns are start and end date time and the last two columns are epoch millisecond start and end time. The date columns in mysql are of type datetime(6).Why is the fractional part not saved in database? I appreciate any insights. I am using grails 2.2 and mysql 5.7.

asked Aug 25 '20 at 09:04

kofhearts

3,607
8
46
79

1

What is `Date`? `java.util.Date` or `java.sql.Date`? Anyway, you should be using `java.sql.Timestamp`. – Andreas Aug 25 '20 at 09:14
What type does `raceStartTime` have? – deHaar Aug 25 '20 at 09:24
*Why is the fractional part not saved in database?* Are you sure that it exists in a value which you save? – Akina Aug 25 '20 at 09:27

fractional second is not being saved in database even though the column type is datetime(6)?

0 Answers0