Curriculum
Course: SQL
Login

Curriculum

SQL

SQL References

0/80

MySQL Functions

0/139

SQL Server Functions

0/84

SQL Quick Ref

0/1
Text lesson

CURDATE

Example

Provide the date of the current day.

SELECT CURDATE();

Definition and Usage

The CURDATE() function retrieves the current date.

Please note that the date is provided in the format “YYYY-MM-DD” (string) or YYYYMMDD (numeric).

Additionally, note that this function is equivalent to the CURRENT_DATE() function.

Syntax

CURDATE()

Technical Details

Works in:

 From MySQL version 4.0

More Examples

Example

Provide the date that comes after the current date by one day.

SELECT CURDATE() + 1;