MySQL: DAY Function

In this guide, we will explain how to use the MySQL DAY function with syntax and examples.

Description

The MySQL DAY function returns the day portion of a date value.

The syntax for the DAY function in MySQL is:

DAY( date_value )

The date or datetime value from which to extract the day.

The DAY function returns the day of the month (a number from 1 to 31) given a date value.
The DAY function is a synonym for the DAYOFMONTH function.
See also the EXTRACT, YEAR, QUARTER, MONTH, WEEK, HOUR, MINUTE, SECOND, and MICROSECOND functions.

The DAY function can be used in the following versions :

MySQL 5.7, MySQL 5.6, MySQL 5.5, MySQL 5.1, MySQL 5.0, MySQL 4.1, MySQL 4.0, MySQL 3.23

Let’s look at some DAY function examples and explore how to use the DAY function.

For example:

mysql> SELECT DAY('2014-01-28');
Result: 28

mysql> SELECT DAY('2014-01-28 15:21:05');
Result: 28

mysql> SELECT DAY('2013-10-15');
Result: 15

This last DAY example would display the day portion of the current system date (current system date is returned by the CURDATE function).

mysql> SELECT DAY(CURDATE());

Next Topic : Click Here