Returns the current date as a DATE value. This function takes no arguments.

Syntax

CURDATE ( )

Notes

SQL statements can refer to CURDATE anywhere they can refer to a DATE expression.

Example

The following example shows how to use the CURDATE function:

INSERT INTO objects (object_owner, object_id, create_date)
     VALUES (USER, 1001, CURDATE()) ;

Compatibility

ODBC compatible