Subject Re: [firebird-support] Getting Milliseconds
Author Helen Borrie
At 09:32 AM 24/05/2007, you wrote:
>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.

CURRENT_TIME(0) is the default (unlike CURRENT_TIMESTAMP, for which
the default is CURRENT_TIMESTAMP(3). )


>How can I get the milliseconds?

CURRENT_TIME(3)

./heLen