dayofyear

Returns the day of the year in "date_expression" as an integer (1-366).

Syntax

dayofyear ( date_expression )