This is MySQL 5.7 column:
`date` datetime(6) NOT NULL
I can see milliseconds using console:
mysql> select * from teq_log_1;
+----+----------------------------+-------+---------+---------+
| id | date | level | message | details |
+----+----------------------------+-------+---------+---------+
| 4 | 2019-08-01 12:23:34.123457 | 2 | test | NULL |
+----+----------------------------+-------+---------+---------+
but I cannot see milliseconds in DBeaver client:
There is format option for the date
column (Right Click on date
column / View/Format / Data Formats ...):
There are Date
, Time
, Timestamp
& Number
types (w/o Datetime
). I set yyyy-MM-dd HH:mm:ss.sss
& yyyy-MM-dd HH:mm:ss.mmm
patterns but without result.
How can I display milliseconds/microseconds for datetime(6)
in DBeaver (v. 6.1.3)?
Turning on Use native date/time format
did it for me.