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

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