MySQL Tutorial MySQL Advanced MySQL Database Account Management MySQL References

MySQL CURDATE() Function



The MySQL CURDATE() function returns the current date. It returns the current date in the following format:

  • Returns the current date as a 'YYYY-MM-DD' format, if used in a string context.
  • Returns the current date as a YYYYMMDD format, if used in a numeric context.

The CURDATE() function is a synonym for the CURRENT_DATE() function.

Syntax

CURDATE()

Parameters

No parameter is required.

Return Value

Returns the current date.

Example 1:

The example below shows the usage of CURDATE() function.

mysql> SELECT CURDATE();
Result: '2021-12-26'

mysql> SELECT CURDATE() + 0;
Result: 20211226

mysql> SELECT CURDATE() + 1;
Result: 20211227

Example 2:

Consider a database table called Employee with the following records:

EmpIDNameCityAgeDate of Joining
1JohnLondon252018-05-25
2MarryNew York242018-10-15
3JoParis272019-06-09
4KimAmsterdam302019-09-21
5RameshNew Delhi282019-10-25

To insert a new record in this table, the following query can be used.

INSERT INTO Employee 
VALUES (6, 'Suresh', 'Mumbai', 28, CURDATE());

-- see the result
SELECT * FROM Employee;

This will produce a result similar to:

EmpIDNameCityAgeDate of Joining
1JohnLondon252018-05-25
2MarryNew York242018-10-15
3JoParis272019-06-09
4KimAmsterdam302019-09-21
5RameshNew Delhi282019-10-25
6SureshMumbai282021-12-26

❮ MySQL Functions

5