neurotech · May 6, 2013 01:14
diff --git a/date-range.sql b/date-range.sql
 date_range(date_on) AS
 (
  SELECT
      DATE((CURRENT DATE) - 14 DAYS)
  FROM sysibm.sysdummy1
  UNION ALL
  SELECT
      date_on + 1 DAY
  FROM date_range
  WHERE date_on < DATE(CURRENT DATE)
 )
	date_range(date_on) AS
	(
	SELECT
	DATE((CURRENT DATE) - 14 DAYS)
	FROM sysibm.sysdummy1
	UNION ALL
	SELECT
	date_on + 1 DAY
	FROM date_range
	WHERE date_on < DATE(CURRENT DATE)
	)
No results found