SHARE
TWEET

Untitled

a guest Jun 17th, 2019 61 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  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;
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
 
Top