CURDATE

MySQL

CURDATE()

Example

SELECT CURDATE();

Output

+------------+
| CURDATE()  |
+------------+
| 2022-01-15 |
+------------+

Explanation

The CURDATE() function in SQL retrieves the current date. The output format is ‘YYYY-MM-DD’. Notice that the actual output will vary depending on the date when the function is called.