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: ✅ Azure Data Explorer ✅ Azure Monitor ✅ Microsoft Sentinel
Provides the integer that represents the day of the year for a specified datetime value.
Syntax
dayofyear(date)
Learn more about syntax conventions.
Parameters
| Name | Type | Required | Description |
|---|---|---|---|
| date | datetime |
✔️ | The datetime for which to determine the day number. |
Returns
The day number of the given year.
Examples
The following example shows how to extract the day of the year from a specified datetime value.
dayofyear(datetime(2015-12-14))
Output
| result |
|---|
| 348 |