I know that,
but now reflects the correct time within a long transaction .
That is why I typed BTW :)

----- Original Message -----
From: "Helen Borrie" <helebor@...>
To: <firebird-support@yahoogroups.com>
Sent: Sunday, October 08, 2006 9:40 PM
Subject: Re: [firebird-support] Exact timestamp w/o using UDF?


> At 12:40 PM 9/10/2006, you wrote:
>>BTW:
>>
>>Current_TimeStamp = Start of transaction and doesn't change till next
>>Transaction is started.
>>
>>declare variabe ThisMoment TimeStamp;
>>ThisMoment = 'now'; Does capture this moments time
>
> Nope. 'NOW' returns zero subseconds too.
>
> ./heLen
>
>
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> 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
>
>
>
>
>
>
>
>
>
>