CURDATE()

Anonymous contributor's avatar
Anonymous contributor
Published Oct 2, 2024
Contribute to Docs

The CURDATE() function returns the current date in the format YYYY-MM-DD unlike DATETIME() which returns the date as well as time.

Syntax

CURDATE()

Example

The below example shows how curdate functions work:

SELECT CURDATE();

Output of the above code is:

2024-09-23

All contributors

Contribute to Docs

Learn SQL on Codecademy