Subject RE: [firebird-support] using timestamp type
Author Alan McDonald
> Hi all
> In FB 1.5 how do I set a TimeStamp variable to now so that I can use it
> to time stamp a record ?
> declare variable F_NOW TimeStamp;
> --
> Regards,
> Grant Brown

set the default value to 'NOW' and let the server do the work (i.e. don't
include the field int he insert statement).
and set a BEFORE UPDATE trigger to set NEW.FIELD='NOW';