Skip to content
Related Articles

Related Articles

CURDATE() Function in MySQL
  • Last Updated : 23 Nov, 2020

CURDATE() function :
This function in MySQL is used to return the current date. The date is returned to the format of “YYYY-MM-DD” (string) or as YYYYMMDD (numeric). This function equals the CURRENT_DATE() function.

Syntax :

CURDATE()

Parameter :

This method does not accept any parameter.

Returns :



It returns the current date.

Example-1 :

Getting the current date in the format of “YYYY-MM-DD” (string).

SELECT CURDATE();

Output :

2020-11-19

Example-2 :

Getting the date 1 day later than the current date in the format of YYYYMMDD (numeric).

SELECT CURDATE() + 1;

Output :

20201120

Example-3 :

Getting the date of 5 days before of current date in the format of YYYYMMDD (numeric).

SELECT CURDATE() + 5;

Output :

20201114

Application : 

This function is used to get the current date or the specified number of days before or after the current date in the two different formats of “YYYY-MM-DD” (string) or as YYYYMMDD (numeric). 

My Personal Notes arrow_drop_up
Recommended Articles
Page :