Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- select * from
- (select adddate('1970-01-01',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 '2019-01-01' and '2019-01-15'
- selected_date
- ---
- 2019-01-01
- 2019-01-02
- 2019-01-03
- 2019-01-04
- selected_date
- ---
- 2019-01-19 00:05:00
- 2019-01-19 00:06:00
- 2019-01-19 00:07:00
- 2019-01-19 00:08:00
- 2019-01-19 00:09:00
- 2019-01-19 00:10:00
- 2019-01-19 00:11:00
Add Comment
Please, Sign In to add comment