Category: SQL Datetime


  • SQL Zero Date Time

    Someone may need to use Zero Date instead of null with datetime datatype SELECT CONVERT(DATETIME,’1900–01–01 00:00:00.000′) Return Result: 1900-01-01 00:00:00.000