报错语句:
cast(Replace(Replace(P.DeliverDate,'.','-'),'/','-') as datetime)
改为
cast(Replace(Replace(P.DeliverDate,'.','-'),'/','-') as datetime2)
使用 datetime2 代替 datetime
报错语句:
cast(Replace(Replace(P.DeliverDate,'.','-'),'/','-') as datetime)
改为
cast(Replace(Replace(P.DeliverDate,'.','-'),'/','-') as datetime2)
使用 datetime2 代替 datetime