34,587
社区成员
发帖
与我相关
我的任务
分享
create table T
(
dt varchar(10)
)
insert T select null
insert T select ''
insert T select '2003-07-01'
insert T select '2004-01-05'
insert T select 'SDS'
select dt,Days from (
select dt,
case when isdate(dt)=1 then datediff(dd,'2003-07-01',dt) end as Days from t
) Temp_A where Days> =0
select dt,Days from (select dt,datediff(dd,'2003-07-01',dt) as Days from T ) Temp_A
where (case when ISDate(dt)=1 then Days else -1 end )>=0