你当前正在访问 Microsoft Azure Global Edition 技术文档网站。 如果需要访问由世纪互联运营的 Microsoft Azure 中国技术文档网站，请访问 https://docs.azure.cn。
dayofmonth()
Applies to: ✅ Microsoft Fabric ✅ Azure Data Explorer ✅ Azure Monitor ✅ Microsoft Sentinel
Returns an integer representing the day number of the given datetime.
Syntax
dayofmonth(date)
Learn more about syntax conventions.
Parameters
| Name | Type | Required | Description |
|---|---|---|---|
| date | datetime |
✔️ | The datetime used to extract the day number. |
Returns
An integer representing the day number of the given datetime.
Example
dayofmonth(datetime(2015-12-14))
Output
| result |
|---|
| 14 |