MySQL: DAY Function
This MySQL tutorial explains how to use the MySQL DAY function with syntax and examples.
Description
The MySQL DAY function returns the day portion of a date value.
Syntax
The syntax for the DAY function in MySQL is:
DAY( date_value )
Parameters or Arguments
- date_value
- The date or datetime value from which to extract the day.
Note
- 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.
Applies To
The DAY function can be used in the following versions of MySQL:
- MySQL 5.7, MySQL 5.6, MySQL 5.5, MySQL 5.1, MySQL 5.0, MySQL 4.1, MySQL 4.0, MySQL 3.23
Example
Let's look at some MySQL DAY function examples and explore how to use the DAY function in MySQL.
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());
Advertisements