Skip to content

Instantly share code, notes, and snippets.

@cetver

cetver/posgtesql_last_date_of_month.md

Last active August 29, 2015 14:26
Show Gist options
  • Save cetver/c0ee6308391c98892c0e to your computer and use it in GitHub Desktop.
Save cetver/c0ee6308391c98892c0e to your computer and use it in GitHub Desktop.
Download ZIP
posgtesql: last date of month
Raw
posgtesql_last_date_of_month.md 
SELECT (date_trunc('MONTH', now()) + INTERVAL '1 MONTH - 1 day 23:59:59')::timestamp without time zone;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment