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 :

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

CURDATE() Function in MySQL

jana_sayantan

Improve

Article Tags :

Similar Reads

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(); P

2 min read

PLSQL | CURRENT_DATE Function

The PLSQL CURRENT_DATE function is used to return the current date in the session time zone. The time zone used is the time zone of the current SQL session as set by the ALTER SESSION command. The PLSQL CURRENT_DATE function uses its value from the Gregorian calendar of datatype DATE. The CURRENT_DA

2 min read

CURTIME() function in MySQL

CURTIME() function in MySQL is used to check the current time. It returns the current time as a value in â€˜hh:mm:ssâ€™ or 'hhmmss' format, depending on whether the function is used in a string or numeric context. Syntax : CURTIME(fsp) Parameters : This method accepts only one parameter. fsp - It specif

2 min read

CURRENT_TIME() function in MySQL

In MySQL, the CURRENT_TIME() function is a valuable tool for retrieving the current system time from the server, providing the exact time in hours, minutes, and seconds. It is widely used in scenarios where tracking or querying the current time is essential without needing the full date. In this art

3 min read

DATE_ADD() Function in MySQL

DATE_ADD() function in MySQL is used to add a specified time or date interval to a specified date and then return the date. Syntax: DATE_ADD(date, INTERVAL value addunit) Parameter: This function accepts two parameters which are illustrated below: date - Specified date to be modified. value addunit

2 min read

ADDDATE() function in MySQL

The ADDDATE() function in MySQL is a powerful tool for adding specific time intervals to date or datetime values. It simplifies data manipulation by allowing us to easily calculate future or adjusted dates based on a given starting point. In this article, we will learn about the ADDDATE() function i

3 min read

EXTRACT() Function in MySQL

The EXTRACT() function in MySQL is a versatile tool used for retrieving specific components of date Whether we need the year, month, day or even the hour or minute. This function simplifies date manipulation and makes queries involving date and time data more efficient and easier to understand. In t

3 min read

UTC_DATE() function in MySQL

UTC_DATE() function in MySQL is used to check current Coordinated Universal Time (UTC) date. It returns the UTC date value in 'YYYY-MM-DD' or YYYYMMDD format, depending on whether the function is used in string or numeric context. Syntax : UTC_DATE OR UTC_DATE() Parameter : This method does not acce

2 min read

DATEDIFF() Function in MySQL

DATEDIFF() function in MySQL is used to return the number of days between two specified date values. Syntax: DATEDIFF(date1, date2) Parameter: This function accepts two parameters as given below: date1: First specified datedate2: Second specified date Returns : It returns the number of days between

2 min read

DAY() Function in MySQL

DAY() function : This function in MySQL is used to return the day of the month for a specified date (a number from 1 to 31). This function equals the DAYOFMONTH() function. Syntax : DAY(date) Parameter : This method accepts a parameter which is illustrated below : date : Specified date to extract th

1 min read