August 9th, 2004, 06:10 AM
It is possible to get the system date in a SQL sentence? I have a trigger that is executed every time a new row is inserted in a table. In the trigger code I would like to store the system date in a column, but I don't know how to get it. I have read something about UDF, but I don't know if there is such UDF for Firebird. I have try to execute a simple 'select sysdate() from xxx' but is does not work. Could anynone help me?
August 10th, 2004, 07:26 AM
NEW.column_name = CURRENT_TIMESTAMP;
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL Server.
Database Workbench: developer IDE for Firebird, MySQL, InterBase, MSSQL Server and Oracle
August 10th, 2004, 09:10 AM
That's exactly what I needed, thanks !!!!