Reputation: 93
I need to find the second Monday of a month e.g. for Sep 2021, the second Monday is 13th How do I do this in Snowflake SQL.
Upvotes: 1
Views: 1249
Found the answer on a separate post
select extract(dow from current_date) = 1 and extract(day from current_date) between 8 and 14;