How can i insert null date values in SQL

[Guest_imported]

i need to insert a null value into SQL so that it displays the word <NULL> instead of 01/01/1900

any ideas

Cheers Mark

 

[rajeevnandanmishra]

Hi Mark,
You can write like this:
INSERT myTable (col1,...,myDateColumn,...)
VALUES (val1,...,null,...)
OR like this
INSERT myTable
SELECT col1,...,null,... FROM ....
Or any other such combination.

Hope it will move you in right direction.

 

[mojorourke]

Update <tablename>
Set <columnName>='<NULL>' Where <columnName>='01/01/1900'