dayofmonth()
Learn how to use the dayofmonth() function to return an integer representing the day of the month.
Provides the day of the month as an integer from a specified datetime value.
Syntax
dayofmonth(date)
Parameters
| Name | Type | Required | Description |
|---|---|---|---|
| date | datetime | ✔️ | The datetime used to extract the day number. |
Returns
Returns an integer representing the day number of the given datetime.
Examples
The following example shows how to extract the day of the month from a specified datetime value.
dayofmonth(datetime(2015-12-14))
Output
| result |
|---|
| 14 |
Feedback
Was this page helpful?
Glad to hear it! Please tell us how we can improve.
Sorry to hear that. Please tell us how we can improve.