34,587
社区成员
发帖
与我相关
我的任务
分享
select
datediff(day,getdate(),last_test_date) as 剩余天数
from equip_regular_check order by 1
select *,datediff(dd,getdate(),last_test_date) as 剩余天数
from equip_regular_check
order by datediff(dd,getdate(),last_test_date) asc
select DATEDIFF(day,GETDATE(), last_test_date) from equip_regular_check order by 1