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 ;

Compatibility

ODBC compatible