CURDATE() Function in MySQL
The CURDATE() 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. In this article, we are going to discuss about CURDATE() function in detail.
Syntax
CURDATE();
Parameter
This method does not accept any parameter.
Returns
It returns the current date.
Query
Getting the current date in the format of YYYY-MM-DD (string).
SELECT CURDATE();
Output
Query
Getting the date 1 day later than the current date in the format of YYYYMMDD (numeric).
SELECT CURDATE() + 1;
Output
Query
Getting the date of 5 days before of current date in the format of YYYYMMDD (numeric).
SELECT CURDATE() + 5;
Output
Query
If you want to subtract the desired number of days from the current date using CURDATE() function.
SELECT CURDATE() -22;
Output
Applications of CURDATE() Function
- 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).
- you can also use CURDATE() function to find the differences between two dates.
- you can also use the CURDATE() function to filter the records from the database.
- you can also use the CURDATE() function to set as a default value for a date.
Contact Us