34,587
社区成员
发帖
与我相关
我的任务
分享
declare @tb table (dt datetime)
insert into @tb select '2007-11-20'
declare @dt datetime
set @dt='2007-11-20'
select * from @tb where dt between dateadd(s,-1,@dt) and dateadd(d,1,@dt)
create table table1(id int,[date] datetime)
go
insert into table1
select 1, '2007-11-19 '
union select 2, '2007-11-18 '
union select 3, '2007-11-19 '
union select 4,getdate()
go
declare @s datetime
declare @e datetime
set @s = '2007-11-18'
set @e = '2007-11-19'
select *
from table1
where datediff(d, [date] ,@s) <=0 and datediff(d, [date] ,@e) >=0
/*
id date
----------- ------------------------------------------------------
1 2007-11-19 00:00:00.000
2 2007-11-18 00:00:00.000
3 2007-11-19 00:00:00.000
(所影响的行数为 3 行)
*/
set @s = '2007-11-19'
set @e = '2007-11-19'
select *
from table1
where datediff(d, [date] ,@s) <=0 and datediff(d, [date] ,@e) >=0
/*
id date
----------- ------------------------------------------------------
1 2007-11-19 00:00:00.000
3 2007-11-19 00:00:00.000
*/
drop table table1