CURRENT_DATE() Function in MySQL
Last Updated :
28 Sep, 2020
In this article, you will see how you can use the current_date function and you will see both formats in the string and numeric respectively.
CURRENT_DATE :
In this function, you will see how you can use the current date function. In MSQSSL, format of date ‘‘YYYY-MM-DD’(in string) format or YYYYMMDD'(in numeric) format.
Syntax :
CURRENT_DATE()
Parameter :
This function does not accept any parameter.
Returns –
It returns the current date.
Example-1 :
CURRENT_DATE() function to find the present date.
SELECT CURRENT_DATE() AS CURR_DATE;
Output :
Example-2 :
CURRENT_DATE() function to find the present date in YYYYMMDD format.
SELECT CURRENT_DATE()+0 AS CURR_DATE;
Output :
Example-3 :
Adding 3 Days to CURRENT_DATE() function to find the next date.
SELECT CURRENT_DATE()+3 AS NEXT_DATE;
Output :
Share your thoughts in the comments
Please Login to comment...