DayNumber_Of_Year Function | VantageCloud Lake - DayNumber_Of_Year - Teradata Vantage

Returns the number of days from the beginning of the year to the specified date.

The DayNumber_Of_Year function provides improved performance compared to using the Sys_Calendar.Calendar system view to get similar results.

• DayNumber_Of_Year Syntax
• td_quarter_end Argument Types
• Example: Querying the Year Ending Immediately after the DATE or TIMESTAMP

ANSI Compliance

This statement is a Teradata extension to the ANSI SQL:2011 standard.

Result Type

The result is an INTEGER value from 1 through 366.

See System Calendar View.