Skip to main content
VeloDB Cloud 4.x is based on Doris 3.x. Versions in this section refer to Doris versions. See Version Mapping.

CURDATE,CURRENT_DATE

Description​

Retrieves the current date and returns it as a DATE type.

Alias​

  • curdate
  • current_date

Syntax​

CURDATE()

Return Value​

The current date.

Examples​

SELECT CURDATE();
+------------+
| CURDATE() |
+------------+
| 2019-12-20 |
+------------+
SELECT CURDATE() + 0;
+---------------+
| CURDATE() + 0 |
+---------------+
| 20191220 |
+---------------+