[MonetDB-users] Microsecond timestamp precision?
16 Feb
2012
16 Feb
'12
8:15 p.m.
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
4475
Age (days ago)
4475
Last active (days ago)
0 comments
1 participants
participants (1)
-
Pete Black