RE: [SQL] NULL DATE

> ok..
> but i have the case
>     INSERT INTO mytab (a,b,c) VALUES(2,'something','now');
>     now i want to set NULL the date item in this tuple.

either:

INSERT INTO mytab (a,b) VALUES (2,''something');

or if it exists already:

UPDATE mytab SET c = NULL;

Taral