CURRENT_DATE
The niladic CURRENT_DATE function has a data type of DATE and returns the date at the time that it is run.
Refer to SET DATESTYLE for further information about date format.
Insert the date of insertion into a row:
INSERT INTO films VALUES ('TM999','Ben Hur',105,CURRENT_DATE,'Action',NULL);
Display CURRENT-DATE:
SELECT CURRENT_DATE AS today; today ------------ 1998-03-31
Full compatibility.