34,590
社区成员
发帖
与我相关
我的任务
分享
declare @tb table (dt datetime)
insert into @tb select null
insert into @tb select ''
insert into @tb select '2003-07-01'
insert into @tb select '2004-01-05'
select * from @tb
where dt>='2003-07-01'
select *
from aaa
where datediff(d,'2003-07-01',getdate())>= 0
select * from tb
where isnull(字段,'')<>'' and 字段<dateadd(dd,1,'2003-07-01')