DATETIME

• gregtm

  SSC Eights!

  Points: 836

  More actions

  November 26, 2002 at 6:12 pm

  #81257

  Is there a way to store NULL in a datetime column? I've tried but It defaults to Jan 01, 1900.

  Thanks in Advance?

  Greg

• Ian Scarlett

  SSC-Insane

  Points: 23197

  More actions

  November 27, 2002 at 1:27 am

  #442519

  You are probably inserting blank into the date (which defaults to Jan 01 1900) instead of NULL e.g.

  INSERT INTO TableX (DateCol,Col1,Col2) values (NULL,'Col1Value','Col2Value')

  I suspect you are doing something like

  INSERT INTO TableX (DateCol,Col1,Col2) values ('','Col1Value','Col2Value')

  Have you defined the column as NULLable?

• Antares686

  SSC Guru

  Points: 125444

  More actions

  November 27, 2002 at 7:59 am

  #442546

  Duplicate post, see responses in thread http://www.sqlservercentral.com/forum/topic.asp?TOPIC_ID=8452&FORUM_ID=8&CAT_ID=1&Topic_Title=DATETIME&Forum_Title=T%2DSQL