Subject Re: [ib-support] Trigger to place date.
Author Ernesto Cullen
If your DB is Dialect 3, you can use

new."posting_date" = current_date;

Ernesto Cullen

----- Original Message -----
From: "jerrypark12357" <jerry_park@...>
To: <>
Sent: Wednesday, July 10, 2002 7:14 PM
Subject: [ib-support] Trigger to place date.

> I'm fairly new to Firebird/Interbase and am in the process of
> designing a database. I couldn't find in the documentation a method of
> creating a trigger to place the current date in a field. I understand
> how to create triggers, just don't know how to do this particular one.
> NEW."posting_date" = [what];
> thanks