Sql 2008 set date field to null

Pictures helped. Didn't match my screen. Incorrect instructions. Too technical. Not enough information. Not enough pictures. Any additional feedback? Submit feedback.

Thank you for your feedback! Ask a Question. Please Sign up or sign in to vote. See more: SQL-Server. Copy Code.

Posted Oct pm Alan Tuscano. Add a Solution. Top Rated Most Recent. Accept Solution Reject Solution. Replace the following line : C.

Posted Oct pm Mehdi Gholam. Alan Tuscano Oct am. Sign up or log in Sign up using Google. Sign up using Facebook. Sign up using Email and Password.

Post as a guest Name. Email Required, but never shown. The Overflow Blog. Stack Gives Back Safety in numbers: crowdsourcing data on nefarious IP addresses.

Featured on Meta. New post summary designs on greatest hits now, everywhere else eventually. Linked Just some inside info on what's happening here.

CASTing a varchar blank results in a value of zero. The date value you are seeing is the result of casting a zero to datetime. Ewan Hampson. I also found that implicit CAST. You can define a default value of 0 for a datetime column and it enters the 'zero' datetime.