[Squirrel-sql-users] no milliseconds for Datetime and Timestamp columns (MySQL)

[Benjamin W. <be...@mm...>]

Hallo,

Im using SQuirrel SQL Client Version 3.1.1 on an Mac and i can't get the
client to show me milliseconds for my datetime or timestamp columns.

Example:
create table test_tab (id varchar(100), start timestamp);
insert into test_tab (id, START) values('TEST', '2010-08-03 06:10:13.240');
SELECT * FROM test_tab;

Result:
ID = TEST; Start = 2010-08-03 06:10:13.0

Settings in Preferences -> Datatypes are:
Date: Use default format (2010-08-03); Interpret DATE columns as TIMESTAMP
Time: Use default format (11:25:14)
Timestamp: Use default format (2010-08-03 11:25:14.738); Use JDBS
standard escape format

Its only a problem with the squirrel client, other clients do show the
milliseconds.

Any ideas or hints?

Thanks
Ben