Column.day_of_year
day_of_year
Group: DateTime
Documentation
Gets the day of the year as a number (1 - 366) from the date stored in the column.  Applies only to columns that hold the Date or Date_Time types. Returns a column of Integer type.