update table with null value

[smapdi]

I'm trying to update a date field with NULL but it keeps getting updated with 0000-00-00

UPDATE construction SET $field = 'NULL'";

When I print the query it returns
UPDATE construction SET $field = ''

I've tried everything I can think of; add quotes, remove quotes, use a variable, but I can't update the data correctly.

[Lars_Berg]

UPDATE construction SET $field = NULL"; 

[smapdi]

no that doesn't work
still puts a value of "" into the database

it seems like it should be that easy

[tsinka]

Hi,

if this is a "not null" column then you'll get 0000-00-00 if you try to update the field to NULL.

So if you really want to allow NULL then change the column so that it allows NULL values. Why do you want to have NULL values ?

Thomas