sql server查询相隔一段时间问题

Question

string DateTime.Now.ToShortDateString();
数据库类型为 datetime

c#中的查询语句为
select * from Example where 现在所在地 like %广州% and 时间 between 2008.04.01 and 2008.05.01"
大家看下,有什么问题啊!
学业不精啊,基础太差啊,没办法又要请教大家了>

Answer 1

第一，实现查询每月13至31日内之间的所有数据

searchtime=datevalue(Trim(Request.Form("datetime1")))
weekw1=searchtime
weekw2=dateadd("m",1,weekw1)
strsql="select * from "&findtype&" where 时间 between #"&weekw1&"# and #"&weekw2&"#"
rs.Open strsql, conn, adOpenStatic

第二，实现查询7月13至7月31日之间的所有数据

SQL Server

Select * from 表名 where DateAdd(year,DateDiff(year,字段名,GETDATE()),字段名) between DateAdd(year,DateDiff(year,''''2003-7-13'''',GETDATE()),''''2003-7-13'''') and DateAdd(year,DateDiff(year,''''2003-7-31'''',GETDATE()),''''2003-7-31'''')

网页

<%
sqlstr="Select * from 表名 where DateAdd(''''yyyy'''',DateDiff(''''yyyy'''',字段名," & now & "),字段名) between DateAdd(''''yyyy'''',DateDiff(''''yyyy'''',#2003-7-13#," & now & "),#2003-7-13#) and DateAdd(''''yyyy'''',DateDiff(''''yyyy'''',#2003-7-31#," & now & "),#2003-7-31#)"
%>

Answer 2

select * from Example where 现在所在地 like '%广州%' and (时间 between '2008.04.01' and '2008.05.01')
看行不?本回答被提问者采纳

Answer 3

时间加上单引号，别的没什么了

Answer 4

建议你使用datediff等时间参数查询，用between效率比较低而且容易出错...