Returns the number of days from the beginning of the year (January 1st) to the specified date.
The td_day_of_year function provides improved performance compared to using the Sys_Calendar.Calendar system view to get similar results.
- td_day_of_year Syntax
- td_day_of_year Argument Types
- Example: Querying for the Number of Days from the Beginning of the Year
See also "Function Name Overloading" in Using Functions with CREATE/REPLACE FUNCTION (SQL Form).
ANSI Compliance
This statement is a Teradata extension to the ANSI SQL:2011 standard.