Jason,
I have a before update trigger on all my tables.
I also have a "LASTUPDATE" field in all my tables.
They go together - you don't need a stored procedure expecially but you can
do it there too or instead of if you really want.

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


I want to get the date and time of the server as part of an SP.
So that I can update a timestamp field in the database.


-----Original Message-----
From: Alan McDonald [mailto:alan@...]
Sent: 21 August 2002 13:29
To: ib-support@yahoogroups.com
Subject: RE: [ib-support] GetDate function for Firebird


you mean "NOW" doesn't do it for you?
-----Original Message-----
From: Jason Fischer [mailto:jfischer@...]
Sent: Wednesday, 21 August 2002 21:17
To: IB Support (E-mail)
Subject: [ib-support] GetDate function for Firebird


Hi All

Is there a GetDate function in firebird that works the same as in SQL
Server.

Thanks


Yahoo! Groups Sponsor
ADVERTISEMENT



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]



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



Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/


Yahoo! Groups Sponsor
ADVERTISEMENT



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]