Home Forums SQL Server 2008 T-SQL (SS2K8) How do I remove nulls from case statements with date fields? RE: How do I remove nulls from case statements with date fields?

  • August 6, 2012 at 5:35 am

    #1521969

    MS SQL implicitly casts a blank string into 1900-01-01 00:00:00 in datetime data type so you're a bit stuck there.

    Not sure why the NULLs are a problem though in your calculation?