Re: Date question....

From: Bruno Wolff III <bruno(at)wolff(dot)to>
To: "Kovalcik, Mike A [ITS]" <mkoval01(at)sprintspectrum(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Date question....
Date: 2003-05-22 15:51:03
Message-ID: 20030522155103.GB1667@wolff.to
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Thu, May 22, 2003 at 10:38:54 -0500,
"Kovalcik, Mike A [ITS]" <mkoval01(at)sprintspectrum(dot)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'

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2003-05-22 15:51:32 Re: After VACUUM, statistics become skewed
Previous Message Kovalcik, Mike A [ITS] 2003-05-22 15:50:10 Re: Date question....