CURDATE

Returns the current date of the system.

Note

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

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