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:

SELECT WEEK_NUMBER_OF_QUARTER_UDF(DATE '2023-01-01'),
WEEK_NUMBER_OF_QUARTER_UDF(DATE '2022-10-27')

Output:

1, 4