dayofyear()

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.

Run the query

dayofyear(datetime(2015-12-14))

Output

result
348