Skip to content

Instantly share code, notes, and snippets.

@crossaidi

crossaidi/1st_of_month.sql

Created November 6, 2013 10:38
Show Gist options
  • Save crossaidi/7334039 to your computer and use it in GitHub Desktop.
Save crossaidi/7334039 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
1st_of_month.sql
(NOW()::date - interval '1 day' * (EXTRACT(DAY FROM NOW()) - 1))::date
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment