Subject Re: [firebird-support] Getting Milliseconds
Author Hans
CURRENT_TIMESTAMP seems to return more detail

----- 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
>
>
>