> Just so there is no confusion:
>
> > >>Current_TimeStamp = Start of transaction and doesn't change till next
> > >>Transaction is started.
>
> Is a bit misleading.
>
> Both 'now' and CURRENT_TIMESTAMP will change during the single
> transaction. This is pretty easy to test
>
> ---
>
> Open iSQL or equiv, and run:
>
> select current_timestamp from RDB$DATABASE;
>
> now wait a few seconds and run in the same window:
>
> select current_timestamp from RDB$DATABASE;

quite... it's current for the operation - not the transaction
another difference:
SELECT CURRENT_TIMSTAMP FROM TABLE works but
SELECT NOW FROM TABLE
or SELECT 'NOW' FROM TABLE
does not work
UPDATE TABLE SET FIELD='NOW' WHERE....
does work however.

Alan