Community discussion forum

avoiding 1/1/1900 in SQL SERVER?

• • Reply

  1 year ago

  by karan_21584

  karan_21584

  Chennai, India

  Joined 2 years ago
  while updating or inserting a record in SQL SERVER, by default the DATETIME variable getting 1/1/1900. i need a trigger, so that whenever UPDATE or INSERT is made in a particular table, and if datetime consist of 1/1/1900, those values should replace as NULL.... can anyone provide the trigger for this? or is there anyother solution?
  
  Currently i m using ASP.NET with C# (.net 2003, 1.1 framework) - KARAN
  Report abuse
• • Reply

  1 year ago

  by karan_21584

  karan_21584

  Chennai, India

  Joined 2 years ago

  none here to answer this questioN?????

  Report abuse