Doug Chamberlin wrote:
--------------------------------------
Just two comments on what Nick wrote.
1) If it is important to have the SYS$CHANGED_AT and SYS$CREATED_AT values
precisely the same after an insert, you might want to change the above to

> new.SYS$CHANGED_AT='NOW';
> new.SYS$CREATED_AT=new.SYS$CHANGED_AT;

That way the NOW function will have no chance of returning two slightly
different values.
--------------------------------------

Isn't there a Date/Time-thingy that is constant during the transaction?

Regards,
Aage J.