|RE: [ib-support] Date and time in Stored Proc
> I would like to have a table holding a list of tables and the date/timeUse the Firebird SQL92-compliant date/time keywords.
> 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.
In a dialect 3 database:
CURRENT_TIME => time only
CURRENT_DATE => date only
CURRENT_TIMESTAMP => date and time