MySQL DAY() Function
Definition and Usage
The DAY() function returns the day of the month for a given date (a number from 1 to 31).
Note: This function equals the DAYOFMONTH() function.
Syntax
DAY(date)
Parameter Values
Parameter | Description |
---|---|
date | Required. The date to extract the day from |
Technical Details
Works in: | From MySQL 4.0 |
---|
More Examples
Example
Return the day of the month for a date:
SELECT DAY("2017-06-15 09:34:21");
Try it Yourself »
Example
Return the day of the month for the current system date:
SELECT DAY(CURDATE());
Try it Yourself »