--- In firebird-support@yahoogroups.com, "Velja Radenkovic"
<velja.r@...> wrote:

>
> Thanks you,
> Velja

You may want to also consider CURRENT_TIMESTAMP.

There is a subtle difference between that and NOW, one holds the value
for the duration of an operation, for the other may be different for
each record affected.

update somelargetable
set somefield = 'NOW';

and

update somelargetable
set somefield = CURRENT_TIMESTAMP;

May have different outcomes.

Adam