Example
SELECT DAYOFMONTH("2017-06-15");Definition and Usage
The DAYOFMONTH() function returns the day of the month for a given date (a number from 1 to 31).
Note
This function equals the DAY() function.
Syntax
DAYOFMONTH(
date
)Parameter Values
| Parameter | Description |
|---|---|
| date | Required. The date to extract the day from |
Technical Details
| Works in: | From MySQL 4.0 |
|---|