SQL - NULL for Date Field

[cslawtom]

I would like to know that how could I insert a NULL into a date field. Many thanks.

 

[buzatuadi]

Try ctod(''). This works.

 

[danceman]

first thing to do is to make sure the structure of the date field is set to allow nulls

then

replace mydat with null Attitude is Everything

 

[rgbean]

As the two responses above point out, there IS a difference between a date field without a value ({ / / }) and one that is .Null. - don't confuse them, they react to comparisons and checks differently!

Rick

 

[cslawtom]

Sorry, I means statement for SQL Server.

Example:

Say record 'ABC' already contains a date "12/31/2002" and would like to replace with NULL. So how to define dddd?

x = "UPDATE Table SET DateFd = dddd WHERE KeyCd = 'ABC'"

= SQLEXEC(gnSQLConnection, x, "&quot

Thanks in advance.

 

[danceman]

to repeat:

the table first has to allow null values. the default is not to allow nulls.

x = "UPDATE Table SET DateFd = NULL WHERE KeyCd = 'ABC'"

this should work with SQL
Attitude is Everything

 

[cslawtom]

Thanks Danceman