Skip to content

Instantly share code, notes, and snippets.

@daleobrien

daleobrien/gist:5140204

Last active December 14, 2015 19:58
Show Gist options
  • Save daleobrien/5140204 to your computer and use it in GitHub Desktop.
Save daleobrien/5140204 to your computer and use it in GitHub Desktop.
Download ZIP
Postgresql SQL statement to generate a range of days between 2 dates
Raw
gistfile1.sql
SELECT
'2010-01-01'::DATE + day - 1 AS day
FROM
generate_series(1, '2011-01-01'::DATE - '2010-01-01'::DATE) AS day;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment