Is there a better way to do this?
-----Original Message-----
From: Bruno Wolff III [mailto:bruno@wolff.to]
Sent: Thursday, May 22, 2003 10:51 AM
To: Kovalcik, Mike A [ITS]
Cc: pgsql-admin@postgresql.org
Subject: Re: [ADMIN] Date question....
On Thu, May 22, 2003 at 10:38:54 -0500,
"Kovalcik, Mike A [ITS]" <mkoval01@sprintspectrum.com> wrote:
> Well....
>
> I set my table up like...
>
> Bday date
>
> Where bday is my column name and date is the data type....
>
> I've tried a lot of things to remove it, but I've had no luck:
>
> UPDATE address SET Bday = '' WHERE addressid = '4'
>
> This is when it gives me the error, but I'm not sure what else to put
> there to make sure it is in date format to remove the date
> completely...
If you are doing things this way then you probably want to use: UPDATE
address SET Bday = NULL WHERE addressid = '4'
