VeloDB Cloud
SQL Reference
SQL Functions
Scalar Functions
Date Time Functions
CURDATE,CURRENT_DATE

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 |
+---------------+