Re: DATE column doesn't like empty string or null value

michael@floog.net writes:
> What command can I use to remove all the 01/01/2001 entries in every row
> and leave it blank.

Set the values to NULL, eg
    UPDATE mytab SET datecol = NULL;

            regards, tom lane