Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Switch services using the Version drop-down list. Learn more about navigation.
Applies to: ✅ Microsoft Fabric ✅ Azure Data Explorer ✅ Azure Monitor ✅ Microsoft Sentinel
Provides the day of the month as an integer from a specified datetime value.
Syntax
dayofmonth(date)
Learn more about syntax conventions.
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 |