Skip to content

Instantly share code, notes, and snippets.

@arumoy

arumoy/round_to_mondya.sql

Created May 27, 2019 09:25
Show Gist options
  • Save arumoy/8f2fd198fb09d72996a1b6beae325934 to your computer and use it in GitHub Desktop.
Save arumoy/8f2fd198fb09d72996a1b6beae325934 to your computer and use it in GitHub Desktop.
Download ZIP
Round any date to nearest Monday
Raw
round_to_mondya.sql
date_sub(date(date), interval MOD(TO_DAYS(date) -2, 7) day)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment