DAY_OF_YEAR

Calculates the day of the year for a given date or datetime

Description	The DAY_OF_YEAR function computes and returns the day of the year for a given date or datetime, indicating which day of the year it is. This can be valuable for time-based analytics, scheduling, or date-based calculations.
Syntax	DAY_OF_YEAR(date)

1. date: The date or datetime for which you want to determine the day of the year.

Example

Table

Event	Event Date
Event A	2023-09-10
Event B	2023-08-25
Event C	2023-01-15

Function

DAY_OF_YEAR(`Event Date`)

Results

DAY_OF_YEAR (integer)
253
237
15