Subject RE: [ib-support] Date and time in Stored Proc
Author Thomas Steinmaurer
> I would like to have a table holding a list of tables and the date/time
> they were last changed. This would be updated by a Stored Procedure
> which is fired by the After Post of each table.
> Is there anyway I can get the current date/time from inside Firebird 1.0
> or will I have to create a UDF.

Use the Firebird SQL92-compliant date/time keywords.

In a dialect 3 database:

CURRENT_TIME => time only
CURRENT_DATE => date only
CURRENT_TIMESTAMP => date and time

Thomas Steinmaurer