sql得到时间 查询2012-06-07到2012-07-05这段时间内所有的日期希望的查询结果为:2012-06-072012-06-082012-06-09...2012-07-032012-07-042012-07-05 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 between '2012-06-07' and '2012-07-05' select * from tabwhere 日期 between '2012-06-07' and '2012-07-05' 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 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 求一条稍微复杂的sql语句。 我学数据库原理 学完之后我能做什么? 一个小问题 asp 连接sql 2000 和2005的方法 如何做在线更新程序 如何将SQL的库转换成ORACLE的库 MYSQL怎么导出数据库极数据? 问一下站内搜索SQL问题 Sql server的事物问题 有关SQL更改密码的问题。 无法将文件复制到映射盘 对于字段值里面有"'"號的值你們是如何处理的?
select * from tab
where 日期 between '2012-06-07' and '2012-07-05'
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
from master..spt_values
where type='P' and dateadd(dd,number-1,'2012-06-07')<='2012-07-05'
/**
dt
----------
2012-06-06
2012-06-07
2012-06-08
2012-06-09
2012-06-10
2012-06-11
2012-06-12
2012-06-13
2012-06-14
2012-06-15
2012-06-16
2012-06-17
2012-06-18
2012-06-19
2012-06-20
2012-06-21
2012-06-22
2012-06-23
2012-06-24
2012-06-25
2012-06-26
2012-06-27
2012-06-28
2012-06-29
2012-06-30
2012-07-01
2012-07-02
2012-07-03
2012-07-04
2012-07-05(30 行受影响)
**/