Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT ADDDATE('2001-01-01', t4.n * 1000 + t3.n * 100 + t2.n * 10 + t1.n * 1) as generated_date
- FROM
- ( (SELECT 0 as n) UNION ALL (SELECT 1 as n) UNION ALL (SELECT 2 as n) UNION ALL (SELECT 3 as n) UNION ALL (SELECT 4 as n) UNION ALL (SELECT 5 as n) UNION ALL (SELECT 6 as n) UNION ALL (SELECT 7 as n) UNION ALL (SELECT 8 as n) UNION ALL (SELECT 9 as n) ) as t1,
- ( (SELECT 0 as n) UNION ALL (SELECT 1 as n) UNION ALL (SELECT 2 as n) UNION ALL (SELECT 3 as n) UNION ALL (SELECT 4 as n) UNION ALL (SELECT 5 as n) UNION ALL (SELECT 6 as n) UNION ALL (SELECT 7 as n) UNION ALL (SELECT 8 as n) UNION ALL (SELECT 9 as n) ) as t2,
- ( (SELECT 0 as n) UNION ALL (SELECT 1 as n) UNION ALL (SELECT 2 as n) UNION ALL (SELECT 3 as n) UNION ALL (SELECT 4 as n) UNION ALL (SELECT 5 as n) UNION ALL (SELECT 6 as n) UNION ALL (SELECT 7 as n) UNION ALL (SELECT 8 as n) UNION ALL (SELECT 9 as n) ) as t3,
- ( (SELECT 0 as n) UNION ALL (SELECT 1 as n) UNION ALL (SELECT 2 as n) UNION ALL (SELECT 3 as n) UNION ALL (SELECT 4 as n) UNION ALL (SELECT 5 as n) UNION ALL (SELECT 6 as n) UNION ALL (SELECT 7 as n) UNION ALL (SELECT 8 as n) UNION ALL (SELECT 9 as n) ) as t4
- where ADDDATE('2001-01-01', t4.n * 1000 + t3.n * 100 + t2.n * 10 + t1.n * 1) <=CURDATE()
Advertisement
Add Comment
Please, Sign In to add comment
