Tom Azernour avatar
Written by Tom Azernour
Updated over a week ago

Type: Function

Function: DAY_OF_YEAR

Syntax: DAY_OF_YEAR(datetime)

Description: Returns the day of the year (between 1 and 366) for the provided datetime.

Sample usage:

  • DAY_OF_YEAR(created_at) returns the day of the year for the created_at field value

  • DAY_OF_YEAR(DATE(2023, 08, 27)) is equal to 239

Did this answer your question?