TD_WEEK_OF_YEAR_UDF
Definition
User-defined function (UDF) that determines which "full week" of the year is based on a date. It is equivalent to the TD_WEEK_OF_YEAR and the WEEKNUMBER_OF_YEAR functions from Teradata.
Parameters
INPUT TIMESTAMP_TZ
Date to get the number of week from.
Returns
A number that represents the week number the date belongs to.
Usage example
Input:
Output:
Last updated