SQL 处理'1900-01-01'

sql server DATE 空值保存后默认值为'1900-01-01'

select (nullif(DeliveryDate,'')) as b, * from dbo.tbItemBill

select (cast(nullif(DeliveryDate,'')as DateTime)  ) as b, * from dbo.tbItemBill

运行结果图示：