Subject Re: [firebird-support] Re: Insert current time and date
Author Lester Caine
Helen Borrie wrote:

> CURRENT_TIME is fixed to the first operation executed by the
> statement. It's not related to the transaction at all. So, if a statement
> updates 10,000 rows, all 10,000 rows will have exactly the same time.
> 'NOW' records the time when the single operation is executed. So, if a
> statement updates 10,000 rows, each row will have the exact time that the
> operation occurred on that row, i.e. the 10,000th row will have a later
> time than the first.

And just to complete the picture. The current versions only provide
accuracy to seconds, even though '.0000' will be added. That is set to
change in FB2 to give the four decimal places.
If you need the fractional accuracy now, you can use the
GetExactTimestamp UDF in the FBUDF.dll library.

Lester Caine
L.S.Caine Electronic Services