DBeaver: display datetime with milliseconds

Alex Gusev picture Alex Gusev · Aug 1, 2019 · Viewed 7k times · Source

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:

enter image description here

There is format option for the date column (Right Click on date column / View/Format / Data Formats ...):

enter image description here

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)?

Answer

Altus picture Altus · May 24, 2020

Turning on Use native date/time format did it for me.