Tutorial Gateway

MySQL CURDATE Function

by

MySQL Curdate function is a MySQL Date Function, which is useful to return the current date value in YYYY-MM-DD or YYYYMMDD format. The syntax of the Curdate Function in MySQL is as shown below:

CURDATE();

MySQL CURDATE Example

The following query shows you the basic use of this curdate function.

SELECT CURDATE();

OUTPUT

MySQL CURDATE Example 1

As you can see from the above screenshot, it is showing today’s date in YYYY-MM-DD format. Let me show you another example with Alias Name.

SELECT CURDATE() AS 'Todays Date';

OUTPUT

MySQL CURDATE Example 2

The following query shows you what happens when adding days to this curdate function.

SELECT CURDATE() + 2 AS 'Date String';

SELECT CURDATE() + 12 AS 'Date String';

OUTPUT

MySQL CURDATE Example 4

From the above screenshot, it added those days to the current date. Next, it is displaying the date in the YYYYMMDD string format.