Discussion: SQL INSERT is empty. the default value is 1900-01-0100:00:00. 000. _ MySQL

Discussion: SQL INSERT is empty. the default value is 1900-01-0100:00:00. 000.

Sql2005 if the field is defined as datetime and inserted as ''(null), the default value is 00:00:00. 000.

Filter the solution when queryingCast (nullif ('','') as datetime)

Select cast (''as datetime)
, Cast (nullif ('','') as datetime)
, Isnull (cast (nullif ('','') as datetime), getdate ())
/*
---------------------------------------------------------------------
00:00:00. 000 NULL 17:18:15. 140

(One row is affected)

*/

BitsCN.com