[MonetDB-users] Microsecond timestamp precision?

16 Feb 2012

      Hi,

The documentation doesn't mention the resolution of the timestamp[1] 
directly, but given the examples for the daytime one can assume that the 
it holds millisecond resolution.

Why then are the trailing zeros below printed out? And is there a way to 
get microsecond resolution for example using mal instead?

sql>DECLARE t timestamp(9);
sql>SET t='2012-02-16 01:15:25.123456';
sql>SELECT t;
+----------------------------+
| single_value               |
+============================+
| 2012-02-16 01:15:25.123000 |
+----------------------------+
1 tuple (1.293ms)

Thanks,
Pete

[1]http://www.monetdb.org/Documentation/SQLreference/Temporal

[MonetDB-users] Microsecond timestamp precision?

Pete Black