it seems following function sql is not working to derive in snowflake .
TO_VARCHAR(DATE_TRUNC(”MONTH”, TO_DATE(YEAROFWEEKISO(DATE) || ”-01-01”, ”YYYY-MM-DD”) + (ISO_WEEK_NUMBER – 1) * 7), ”YYYY-MM”) AS ISO_MONTH
How to derive ISO_MONTH in snowflake
New contributor
Anjan Ganesh is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.