CURDATE()

USAGE

CURDATE()

DETAILS

CURDATE() is a date-time function that returns the current date in the currently active timezone.

When called in string context, the return value is formatted as YYYY-MM-DD.

When called in numeric context, the return value is formatted as YYYYMMDD.

See UTC_DATE() for an equivalent function using the UTC timezone.

EXAMPLES

SELECT CURDATE();

+------------+
| CURDATE()  |
+------------+
| 2020-11-06 |
+------------+

SELECT CURDATE()+0;

+-------------+
| CURDATE()+0 |
+-------------+
|    20201106 |
+-------------+

CHANGE HISTORY