Returns the day of the year in the argument as a short integer value in the range of 1-366. The argument date_expression can be the name of a column, the result of another scalar function, or a date or timestamp literal.
Syntax
DAYOFYEAR ( date_expression )
Notes
The argument to the function must be of type DATE.
The result is of type SHORT.
If the argument expression evaluates to NULL, the result is NULL.
Example
This example illustrates the DAYOFYEAR function:
SELECT *
FROM orders
WHERE DAYOFYEAR (order_date) = 300 ;
The argument to the function must be of type DATE.