CURRENT_DATE() Function in MySQL

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 :

CURR_DATE
2020-09-22

Example-2 : CURRENT_DATE() function to find the present date in YYYYMMDD format.

SELECT CURRENT_DATE()+0 AS CURR_DATE;

Output :

CURR_DATE
20200922

Example-3 : Adding 3 Days to CURRENT_DATE() function to find the next date.

SELECT CURRENT_DATE()+3 AS NEXT_DATE;

Output :

NEXT_DATE
20200925