"1/1/1900 12:00:00 AM" Date Problem

• aniket-750033

  Mr or Mrs. 500

  Points: 599

  More actions

  June 27, 2009 at 1:37 am

  #135468

  In my application, there is one Datetime field. While saving if the date field is not selected it stores "1/1/1900 12:00:00 AM" in database. I want to store "NULL" [/i] instead. Please help me resolve this problem.

• arun.sas

  SSChampion

  Points: 11831

  More actions

  June 27, 2009 at 2:27 am

  #1016371

  Hi,

  insert the table value as null,don't pass the value like '',' '

  or

  put the table column as null

  like

  CREATE TABLE #TEMP

  (

  DATE1 DATETIME NOT NULL,

  DATE2 DATETIME NULL

  )

  INSERT INTO #TEMP

  SELECT '2008-05-05',NULL

  UNION ALL

  SELECT '','2008-05-06'

  SELECT *FROM #TEMP

  ARUN SAS

• Gail Shaw

  SSC Guru

  Points: 1004514

  More actions

  June 27, 2009 at 3:43 am

  #1016381

  Duplicate post. No replies to this thread please. Direct replies to:http://www.sqlservercentral.com/Forums/Topic743086-149-1.aspx

  Gail Shaw
  Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
  SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

  We walk in the dark places no others will enter
  We stand on the bridge and no one may pass

• arun.sas

  SSChampion

  Points: 11831

  More actions

  June 27, 2009 at 3:53 am

  #1016383

  Hi Shaw,

  Another topic having the same issue

  See the link

  http://www.sqlservercentral.com/Forums/Topic743085-149-1.aspx

  I will edit the link there.

  ARUN SAS