> 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';

Alan