dayofyear()

Applies to: ✅ Microsoft Fabric ✅ Azure Data Explorer ✅ Azure Monitor ✅ Microsoft Sentinel

Returns the integer number represents the day number of the given year.

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.

Example

Run the query

dayofyear(datetime(2015-12-14))

Output

result
348