Robert Gilland wrote:
I am testing time critical stored procedures in Firebird 2, but the CURRENT_TIME token does not output milliseconds.
select CURRENT_TIME from rdb$database;
always returns 24/5/2007 09:22:000
How can I get the milliseconds?
Helen Borrie answers:
CURRENT_TIME translates into CURRENT_TIME(0), unlike CURRENT_TIMESTAMP, for which the default is CURRENT_TIMESTAMP(3). Use CURRENT_TIME(3) to get the milliseconds.