select * from t_emp where riqi between ‘2010-08-27’and ‘2010-09-26’
是日期中包含 1 ,6 的? declare @t table (rq datetime) insert into @t values ('2009-10-01 15:12:21') insert into @t values ('2009-10-02 15:12:21') insert into @t values ('2009-10-03 15:12:21') insert into @t values ('2009-10-04 15:12:21') insert into @t values ('2009-10-05 15:12:21') insert into @t values ('2009-10-06 15:12:21') insert into @t values ('2009-10-07 15:12:21') insert into @t values ('2009-10-11 15:12:21') insert into @t values ('2009-10-12 15:12:21') insert into @t values ('2009-10-15 15:12:21') insert into @t values ('2009-10-16 15:12:21')select * from @t where right(convert(char(10),rq,120),1) in (1,6) and rq between '2009-10-5' and '2009-10-17'-- rq 2009-10-06 15:12:21.000 2009-10-11 15:12:21.000 2009-10-16 15:12:21.000
select * from t_emp where 日期 between '2010-08-27' and '2010-09-26'select * from t_emp where convert(varchar(10),日期,120) between '2010-08-27' and '2010-09-26'
where riqi between ‘2010-08-27’and ‘2010-09-26’
declare @t table (rq datetime)
insert into @t values ('2009-10-01 15:12:21')
insert into @t values ('2009-10-02 15:12:21')
insert into @t values ('2009-10-03 15:12:21')
insert into @t values ('2009-10-04 15:12:21')
insert into @t values ('2009-10-05 15:12:21')
insert into @t values ('2009-10-06 15:12:21')
insert into @t values ('2009-10-07 15:12:21')
insert into @t values ('2009-10-11 15:12:21')
insert into @t values ('2009-10-12 15:12:21')
insert into @t values ('2009-10-15 15:12:21')
insert into @t values ('2009-10-16 15:12:21')select *
from @t where right(convert(char(10),rq,120),1) in (1,6)
and rq between '2009-10-5' and '2009-10-17'--
rq
2009-10-06 15:12:21.000
2009-10-11 15:12:21.000
2009-10-16 15:12:21.000