From \doc\Firebird_v2...ReleaseNotes.pdf

Sub-second Values Enabled for Time and DateTime Variables
D. Yemanov
CURRENT_TIMESTAMP, 'NOW' Now Return Milliseconds
The context variable CURRENT_TIMESTAMP and the date/time literal 'NOW' will
now return the
Data Manipulation Language (DML)
31

sub-second time part in milliseconds.
Seconds Precision Enabled for CURRENT_TIME and CURRENT_TIMESTAMP
CURRENT_TIME and CURRENT_TIMESTAMP now optionally allow seconds precision
The feature is available in both DSQL and PSQL.
Syntax Pattern
CURRENT_TIME [(<seconds precision>)]
CURRENT_TIMESTAMP [(<seconds precision>)]
Examples
1. SELECT CURRENT_TIME FROM RDB$DATABASE;
2. SELECT CURRENT_TIME(3) FROM RDB$DATABASE;
3. SELECT CURRENT_TIMESTAMP(3) FROM RDB$DATABASE;
Note
1. The maximum possible precision is 3 which means accuracy of 1/1000 second
(one millisecond).
This accuracy may be improved in the future versions.
2. If no seconds precision is specified, the following values are implicit:
 0 for CURRENT_TIME
 3 for CURRENT_TIMESTAMP

----- Original Message -----
From: "robertgilland" <robert_gilland@...>
To: <firebird-support@yahoogroups.com>
Sent: Wednesday, May 23, 2007 5:32 PM
Subject: [firebird-support] Getting Milliseconds


>I am testing time critical stored procedures.
> But the CURRENT_TIME token does not output milliseconds
>
> I am using Firebird 2
>
> select CURRENT_TIME
> from rdb$database
>
> returns
>
> 24/5/2007 09:22:000
>
> always.
>
> How can I get the milliseconds?
>
> Kind Regards,
>
> Robert.
>
>
>
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://www.firebirdsql.org and click the Resources item
> on the main (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Yahoo! Groups Links
>
>
>