Example
SELECT DAY("2017-06-15");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 |
|---|