Tutorial Gateway

MySQL CURDATE Function

by

MySQL Curdate is a Date Function, which is used to return the current date value in YYYY-MM-DD or YYYYMMDD format. In this article, we will show you, How to use this Curdate function in MySQL with example.

MySQL CURDATE Syntax

The basic syntax of the Curdate() Function in MySQL is as shown below:

CURDATE();

MySQL CURDATE Example

The following query will show 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 will show you, what happens when add 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 current date. Next, it is displaying the date in YYYYMMDD string format

Thank You for Visiting Our Blog