WEEKNUMBER_OF_MONTH_UDF
Definition
Determine which month of the year a date belongs to.
PUBLIC.WEEKNUMBER_OF_MONTH_UDF(INPUT TIMESTAMP_TZ)Parameters
INPUT TIMESTAMP_TZ
The date to het the number of month from.
Returns
A number that represents the month number that the date belongs to.
Usage example
Input:
SELECT PUBLIC.WEEKNUMBER_OF_MONTH_UDF(DATE '2022-05-21')Output:
3Last updated