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