WEEK_NUMBER_OF_QUARTER_COMPATIBLE_UDF
This is a deprecated version of the SnowConvert documentation, please visit the official site HERE.
Definition
Returns the week number from the start of the quarter to the specified date. It has the same behavior as the WEEKNUMBER_OF_QUARTER(DATE, 'ISO') function with Teradata calendar.
PUBLIC.WEEK_NUMBER_OF_QUARTER_UDF(INPUT TIMESTAMP_TZ)Parameters
INPUT TIMESTAMP_TZ
The date to get the week number of the quarter.
Returns
An integer that represents the number of the week in the quarter.
Usage example
Input:
Output:
Last updated