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(at)sss(dot)pgh(dot)pa(dot)us>:

> michael(at)floog(dot)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
>