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
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
Leave a Reply