This is a deprecated version of the SnowConvert documentation, please visit the official site HEREarrow-up-right.
Defines in which week of the month a given date is.
PUBLIC.WEEK_OF_MONTH_UDF(INPUT TIMESTAMP_TZ)
INPUT TIMESTAMP_TZ
INPUT
The date to get which week of the month it belongs to.
A varchar that showcases the week of a month of the date.
Input:
Output:
Last updated 1 year ago
SELECT PUBLIC.WEEK_OF_MONTH_UDF(DATE '2021-10-26');
'4'
