Advertisement
Guest User

Untitled

a guest
Jun 17th, 2019
88
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.19 KB | None | 0 0
  1. WITH RECURSIVE recSQL(day, date) AS (
  2. SELECT 0, CURRENT_DATE
  3. UNION ALL
  4. SELECT day + 1, CURRENT_DATE + day +1
  5. FROM recSQL
  6. WHERE recSQL.day < 146
  7. )
  8. SELECT *
  9. FROM recSQL;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement