56,682
社区成员
发帖
与我相关
我的任务
分享MySQL 日期
1. 我输入2个时间 . 2017-05-01 , 2017-05-05
2. 我不希望借助任何实体表,函数,存储过程得到以下结果
结果 :
2017-05-01
2017-05-02
2017-05-03
2017-05-04
2017-05-05
PS : 我的思路是先2个日期相减得到 2017-05-01, 2017-05-02, 2017-05-03, 2017-05-04 , 2017-05-05
希望我说清楚了..
2. 我不希望借助任何实体表,函数,存储过程得到以下结果
结果 :
2017-05-01
2017-05-02
2017-05-03
2017-05-04
2017-05-05
PS : 我的思路是先2个日期相减得到 2017-05-01, 2017-05-02, 2017-05-03, 2017-05-04 , 2017-05-05
希望我说清楚了..
...全文
请发表友善的回复…
发表回复
ACMAIN_CHM 2017-07-19
- 打赏
- 举报
set @d1='2017-05-01';
set @d2='2017-05-05';
select @d1+interval sq day as mydate
from (
select 0 as sq union all
select 1 union all
select 2 union all
select 3 union all
select 4 union all
select 5 union all
select 6 union all
select 7 union all
select 8 union all
select 9 union all
select 10 union all
select 11 union all
select 12 union all
select 13 union all
select 14 union all
select 15 union all
select 16 union all
select 17 union all
select 18 union all
select 19 union all
select 20 union all
select 21 union all
select 22 union all
select 23 union all
select 24 union all
select 25 union all
select 26 union all
select 27 union all
select 28 union all
select 29 union all
select 30 union all
select 31 union all
select 32 union all
select 33 union all
select 34 union all
select 35 union all
select 36 union all
select 37 union all
select 38 union all
select 39 union all
select 40 union all
select 41 union all
select 42 union all
select 43 union all
select 44 union all
select 45 union all
select 46 union all
select 47 union all
select 48 union all
select 49 union all
select 50 union all
select 51 union all
select 52 union all
select 53 union all
select 54 union all
select 55 union all
select 56 union all
select 57 union all
select 58 union all
select 59 union all
select 60 union all
select 61 union all
select 62 union all
select 63 union all
) t
where @d1+interval<=@d2
wsy24680 2017-07-17
- 打赏
- 举报
用时间戳加个循环计算
zjcxc 2017-07-17
- 打赏
- 举报
确定的两值值，可以拼 sql 出来结果，不确定的值，那就无法拼了
二月十六 2017-07-16
- 打赏
- 举报
系统函数也不能用吗？
