22,209
社区成员
发帖
与我相关
我的任务
分享
select *
from tb
where
datediff(dd,C,'2009-02-03')=0 OR datediff(dd,D,'2009-02-03')=0
---测试数据---
if object_id('[tb]') is not null drop table [tb]
go
create table [tb]([C] datetime,[D] datetime)
insert [tb]
select '2009-02-03','2009-02-04' union all
select '2009-02-04','2009-02-02'
---查询---
select *
from tb
where
datediff(dd,case when c>d then c else d end,'2009-02-03')=0
/**
C D
------------------------------------------------------ ------------------------------------------------------
(所影响的行数为 0 行)
**/
select *
from tb
where
datediff(dd,case when c>d then c else d end,'2009-02-04')=0
/**
C D
------------------------------------------------------ ------------------------------------------------------
2009-02-03 00:00:00.000 2009-02-04 00:00:00.000
2009-02-04 00:00:00.000 2009-02-02 00:00:00.000
(所影响的行数为 2 行)
**/
select *
from tb
where
datediff(dd,case when c>d then c else d end,'2009-02-03')=0