SQL Edit Date to Null Help

[excalibur78]

I'm looking to figure out a way to update a SQL record with existing data in a datetime field with null. When I blank the field I get 1/1/1900 not null. I'm using ADO to do the manipulation of the data. Any help could be great.


David

 

[tlbroadbent]

Have you tried to set the value of the datetime column to NULL.

Update table
set colname=NULL Terry L. Broadbent - DBA
SQL Server Page:

http://tlbroadbent.home.attbi.com/sql/sql_articles.htm

If you want to get the best answer for your question read faq183-874.

 

[JamesLean]

This SQL statement should work:

UPDATE tablename
SET datecol = NULL

You can add a WHERE clause if you only want to update certain rows.

If this is what you're doing and it's not working, check you haven't got a DEFAULT set on that column.

 

[tlbroadbent]

The default would only affect INSERTS, not UPDATES. Terry L. Broadbent - DBA
SQL Server Page:

http://tlbroadbent.home.attbi.com/sql/sql_articles.htm

If you want to get the best answer for your question read faq183-874.

 

[JamesLean]

Correct. Just checking you're paying attention.. ;-)

 

[excalibur78]

Thanks that worked.