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

Tom,

Thanks for the speedy reply.
I'm going to ssh to my home-box and give this a try right now.

Mike


Quoting Tom Lane <tgl@sss.pgh.pa.us>:

> 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
>