sql得到时间
查询2012-06-07到2012-07-05这段时间内所有的日期
希望的查询结果为：
2012-06-07
2012-06-08
2012-06-09
...
2012-07-03
2012-07-04
2012-07-05

[解决办法]
between '2012-06-07' and '2012-07-05'
[解决办法]

SQL code

select * from tabwhere 日期 between '2012-06-07' and '2012-07-05'
[解决办法]
SQL code
declare @st datetime = '2012-06-07'declare @et datetime = '2012-07-05'declare @t datetime set @t = @st while(@t<=@et)begin    print convert(varchar(10),@t,120)    set @t = dateadd(day,1,@t)end
[解决办法]
SQL code
select convert(varchar(10),dateadd(dd,number-1,'2012-06-07'),120) as dtfrom master..spt_valueswhere type='P' and dateadd(dd,number-1,'2012-06-07')<='2012-07-05'/**dt----------2012-06-062012-06-072012-06-082012-06-092012-06-102012-06-112012-06-122012-06-132012-06-142012-06-152012-06-162012-06-172012-06-182012-06-192012-06-202012-06-212012-06-222012-06-232012-06-242012-06-252012-06-262012-06-272012-06-282012-06-292012-06-302012-07-012012-07-022012-07-032012-07-042012-07-05(30 行受影响)**/
[解决办法]
http://topic.csdn.net/u/20090906/17/a91cd31e-abf7-4190-8486-c5491aa63c71.html?seed=1380177511&r=59598572#r_59598572