it's a trigger..
CREATE TRIGGER triggername FOR tablename
ACTIVE BEFORE UPDATE POSITION 0
AS
BEGIN
NEW.LASTUPDATE = 'NOW';
END

The new. and old. prefixes are available in triggers.

You command would do the whole table... did you want to do that? Surely not
every time you update a record.
A DATESTAMP field will contain the date and time

Alan
-----Original Message-----
From: Jason Fischer [mailto:jfischer@...]
Sent: Wednesday, 21 August 2002 21:56
To: ib-support@yahoogroups.com
Subject: RE: [ib-support] GetDate function for Firebird


So what would a update command look like for updating a date field to the
current time

UPDATE X
Set MyDate = TIMESTAMP


I want the entire date and time to be stored.
Will the above be correct.


To unsubscribe from this group, send an email to:
ib-support-unsubscribe@egroups.com



Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.



[Non-text portions of this message have been removed]