CURDATE¶

Returns the current date of the system.

Note

This function is provided for compatibility with MySQL and IBM DB2.

Syntax¶

CURDATE() --> DATE

Arguments¶

None

Returns¶

The current system date, with type DATE.

Notes¶

This function is equivalent to CURRENT_DATE.
To get the date and time, see CURRENT_TIMESTAMP.

Examples¶

Get the current system date¶

master=> SELECT CURRENT_DATE, CURRENT_DATE(), CURDATE();
date       | date0      | date1
-----------+------------+-----------
2019-12-07 | 2019-12-07 | 2019-12-07