Date series on redshift

date_series_redshift.sql

WITH date_series_bounds AS (
	SELECT date('2012-12-21') as start, date('2013-08-23') as end
), date_series AS (
	select date(days.start + days.interval)
	from (
		select bounds.start, generate_series(0, bounds.end - bounds.start) AS interval from date_series_bounds bounds
	) as days
)
select * from date_series
-- 2012-12-21
-- 2012-12-22
-- ...
-- 2013-08-22
-- 2013-08-23