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