Subject | RE: [firebird-support] Date stamp entry |
---|---|
Author | Alan McDonald |
Post date | 2004-03-15T03:18:23Z |
> Hello - newbie question ...if it's a field you will be inserting at some point then you need a trigger
>
> How to : generate automatic datestamp entry on each new record in
> firebird ?
>
to set NEW.FIELD1 = 'NOW'; or CURRENT_TIMESTAMP. Do this on the before
insert trigger of the table.
If the field is not going to be inserted you can just set it's default value
to 'NOW' or CURRENT_TIMESTAMP and this will be the same as the trigger
method but no code required.
Alan