查询问题

Question

where datediff(dd,'2005-04-15',rq)>=0 and datediff(dd,rq,'2005-04-17')<=0

Answer 1

其中rq可以是char，varchar或者datetime

Answer 2

--如果日期格式不规范select * from 表 where cast(rq as datetime) between '2005-04-15' and '2005-04-17'

Answer 3

--如果日期是标准的yyyy=-mm-dd的格式,直接写
select * from 表 where rq between '2005-04-15' and '2005-04-17'

Answer 4

select * from test where rq like '2005-04-1[5-7]'

Answer 5

select * from 表 where cast(rq as datetime) between '2005-04-15' and '2005-04-17'

Answer 6

Select * from TableName 
Where DateDiff(d,rq,'2005-04-15')<=0 And DateDiff(d,rq,'2005-04-17')>=0

Answer 7

where datediff(dd,'2005-04-15',rq)>=0 and datediff(dd,rq,'2005-04-17')>=0

Answer 8

select * 
from 表 
where convert(datetime,rq) between '2005-04-15' and '2005-04-17'