这个语法不通过的。 你可以这样select * from FeiLongMessage where FeiLongBeginTime >='2008-01-06' and FeiLongBeginTime <='2008-01-10'
select * from FeiLongMessage where FeiLongBeginTime between '2008-01-06' and '2008-01-10'
不过这样是不包含1月10日的,要包含的可以这样select * from FeiLongMessage where FeiLongBeginTime between '2008-01-06' and '2008-01-11' --或者 select * from FeiLongMessage where FeiLongBeginTime>'2008-01-06' and FeiLongBeginTime<'2008-01-11'
select * from FeiLongMessage where FeiLongBeginTime >= '2008-01-06' and FeiLongBeginTime<'2008-01-11'
select * from FeiLongMessage where FeiLongBeginTime between '2008-1-6' and '2008-1-10 23:59:59' 结果包括1-6和1-10号的,sql默认会在日期后面补0
declare @FeiLongMessage table (FeiLongBeginTime varchar(10)) insert into @FeiLongMessage select '2008-1-6a' union all select '2008-1-5d' union all select '2008-4-3d' union all select '2008-1-7s' union all select '2008-6-4d' union all select '2008-4-2s' union all select '2008-1-10a'select * from @FeiLongMessage /* FeiLongBeginTime ---------------- 2008-1-6a 2008-1-5d 2008-4-3d 2008-1-7s 2008-6-4d 2008-4-2s 2008-1-10a *//*想要的结果*/ /* FeiLongBeginTime ---------------- 2008-1-6a 2008-1-7s 2008-1-10a */楼主的意思是想要这样的结果吧?
你可以这样select * from FeiLongMessage where FeiLongBeginTime >='2008-01-06' and FeiLongBeginTime <='2008-01-10'
--或者
select * from FeiLongMessage where FeiLongBeginTime>'2008-01-06' and FeiLongBeginTime<'2008-01-11'
结果包括1-6和1-10号的,sql默认会在日期后面补0
declare @FeiLongMessage table (FeiLongBeginTime varchar(10))
insert into @FeiLongMessage
select '2008-1-6a' union all
select '2008-1-5d' union all
select '2008-4-3d' union all
select '2008-1-7s' union all
select '2008-6-4d' union all
select '2008-4-2s' union all
select '2008-1-10a'select * from @FeiLongMessage
/*
FeiLongBeginTime
----------------
2008-1-6a
2008-1-5d
2008-4-3d
2008-1-7s
2008-6-4d
2008-4-2s
2008-1-10a
*//*想要的结果*/
/*
FeiLongBeginTime
----------------
2008-1-6a
2008-1-7s
2008-1-10a
*/楼主的意思是想要这样的结果吧?