CURRENT_DATE

Returns the current date of the system.

Note

This function has a special ANSI SQL form and can be called without parentheses.

Syntax

CURRENT_DATE() --> DATE

CURRENT_DATE --> DATE

Arguments

None

Returns

The current system date, with type DATE.

Notes

  • This function has a special ANSI SQL form and can be called without parentheses.

  • This function is equivalent to CURDATE.

  • 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