YESTERDAY

Returns current date.

Syntax

TODAY()

Return Type

Datetime object, returns date in “YYYY-MM-DD” format.

Examples

mysql> select TODAY();
+------------+
| TODAY()    |
+------------+
| 2021-09-03 |
+------------+