1

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.

Ken White
  • 123,280
  • 14
  • 225
  • 444
reachbgk
  • 83
  • 1
  • 8
  • Just find month number of current date. Then increase month by 1. Then find starting week number then increase week by 1. Get Monday of this week. – Umesh Yadav Sep 24 '21 at 01:51

1 Answers1

1

Found the answer on a separate post

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