Discussion: SQL Insert NULL, default 1900-01-01 00:00:00.000 solution detailed _mysql

sql2005 If the type of field definition is datetime, insert as ' (empty), then the default value is 1900-01-01 00:00:00.000

Filter cast (Nullif (', ') as DateTime) when resolving queries

Copy Code code as follows:

Select CAST (' as DateTime ')
, Cast (Nullif (', ') as DateTime)
, IsNull (CAST (Nullif (', ') as DateTime), GETDATE ())
/*
----------------------- ----------------------- -----------------------
1900-01-01 00:00:00.000 NULL 2009-02-25 17:18:15.140

(1 rows affected)

*/