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.
Applies to: ✅ Microsoft Fabric ✅ 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 |