CURRENT_DATE SQL function
Syntax
CURRENT_DATE
Description
CURRENT_DATE returns the current date as a DATE value. A FairCom DB SQL statement can refer to CURRENT_DATE anywhere you can refer to a DATE expression.
Example
INSERT INTO objects(object_owner, object_id,create_date)
VALUES(user, 1002, CURRENT_DATE) ;
Note: SQL-99 compatible