Insert null empty value in sql datetime column by default

Question

How do I create a table in SQL server with the default DateTime as empty  not 1900-01-01 00 00 00 000 that I get   I mean  if there is no value inserted  the default value should be null  empty  etc

User · Answer

define it like your field DATETIME NULL DEFAULT NULL dont insert a blank string  insert a NULL INSERT INTO x your field VALUES NULL

User · Answer

if there is no value inserted  the default value should be null empty   In the table definition  make this datetime column allows null  be not defining NOT NULL       DateTimeColumn DateTime           I HAVE ALLOWED NULL VARIABLES THOUGH    Then   just insert NULL in this column   INSERT INTO Table name  datetimeColumn       VALUES  foo bar   NULL         Or  you can make use of the DEFAULT constaints       DateTimeColumn DateTime DEFAULT NULL        Then you can ignore it completely in the INSERT statement and it will be inserted withe the NULL value   INSERT INTO Table name       VALUES  foo bar

User · Answer

Ozi  when you create a new datetime object as in datetime foo   new datetime    foo is constructed with the time datetime minvalue   in building a parameterized query  you could check to see if the values entered are equal to datetime minvalue    -Just a side thought  seems you have things working

User · Answer

I was having the same issue this morning  It appears that for a DATE or DATETIME field  an empty value cannot be inserted  I got around this by first checking for an empty value   mydate       and if it was empty setting mydate    NULL  before insert   The DATE and DATETIME fields don t behave in the same way as VARCHAR fields

User · Answer

you can use like this  string Log In Val    Convert ToString attenObj Log In      quot  quot     quot Null quot     quot   quot     quot   quot    Convert ToString attenObj Log In     quot    quot

[sql] Insert null/empty value in sql datetime column by default

Examples related to sql