sql server - SQL cast datetime - Stack Overflow
In SQL Server 2005, why does: PRINT Cast('' AS datetime) display: Jan 1 1900 12:00AM I would have thought it should be null? ... It's because empty string '' is not NULL. If you do: select Cast(null AS datetime) OUTPUT: NULL (1 row(s) affected)...