DBeaver: display datetime with milliseconds

Question

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

Answer 1

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

Answer 2

Using uppercase SSS as in yyyy-MM-dd HH:mm:ss.SSS shows milliseconds - you were using lowercase sss