WEEK_NUMBER_OF_QUARTER_ISO_UDF

This is a deprecated version of the SnowConvert documentation, please visit the official site HERE.

Definition

Determines the week number from the start of the quarter to the specified date. It has the same behavior as WEEKNUMBER_OF_QUARTER(DATE, 'ISO') function with ISO calendar from Teradata.

PUBLIC.WEEK_NUMBER_OF_QUARTER_ISO_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 WEEKNUMBER_OF_QUARTER(DATE '2022-05-01', 'ISO'),
WEEKNUMBER_OF_QUARTER(DATE '2022-07-06', 'ISO')

Output:

4, 1