Skip to content

Instantly share code, notes, and snippets.

@oshanz

oshanz/sql get dates in list

Created October 2, 2014 04:47
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save oshanz/36218a36a935df186192 to your computer and use it in GitHub Desktop.
Save oshanz/36218a36a935df186192 to your computer and use it in GitHub Desktop.
Download ZIP
Mysql Date List
Raw
sql get dates in list
select
selected_date
from
(select
adddate('2014-02-10', t4.i * 10000 + t3.i * 1000 + t2.i * 100 + t1.i * 10 + t0.i) selected_date
from
(select 0 i union select 1 union select 2 union select 3 union select 4 union select 5 union select 6 union select 7 union select 8 union select 9) t0, (select 0 i union select 1 union select 2 union select 3 union select 4 union select 5 union select 6 union select 7 union select 8 union select 9) t1, (select 0 i union select 1 union select 2 union select 3 union select 4 union select 5 union select 6 union select 7 union select 8 union select 9) t2, (select 0 i union select 1 union select 2 union select 3 union select 4 union select 5 union select 6 union select 7 union select 8 union select 9) t3, (select 0 i union select 1 union select 2 union select 3 union select 4 union select 5 union select 6 union select 7 union select 8 union select 9) t4) v
where
selected_date between '2014-02-10' and '2014-02-15'
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment