以下这句会报错,因为ccedate是文本型
and datediff(day,ccedate,getdate()) <=360
改为下面这句,注意是datetime2 不是datetime
and datediff(day,cast( ccedate as datetime2),getdate()) <=360
以下这句会报错,因为ccedate是文本型
and datediff(day,ccedate,getdate()) <=360
改为下面这句,注意是datetime2 不是datetime
and datediff(day,cast( ccedate as datetime2),getdate()) <=360