reachbgk
reachbgk

Reputation: 93

How to find second Monday of month

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

Answers (1)

reachbgk
reachbgk

Reputation: 93

Found the answer on a separate post

select 
extract(dow from current_date) = 1 
and extract(day from current_date) between 8 and 14;

Upvotes: 1

Related Questions