Subject Re: [ib-support] Date and time in Stored Proc
Author Martijn Tonies
Hi,

> 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.

CURRENT_TIME - CURRENT_DATE - CURRENT_TIMESTAMP

And also take a look at www.iblogmanager.com


With regards,

Martijn Tonies
Database Workbench - the developer tool for InterBase & Firebird
Upscene Productions
http://www.upscene.com

"This is an object-oriented system.
If we change anything, the users object."