Re: Date question....

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

Thanks,
Mike

-----Original Message-----
From: Bruno Wolff III [mailto:bruno(at)wolff(dot)to]
Sent: Thursday, May 22, 2003 7:13 AM
To: Kovalcik, Mike A [ITS]
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: [ADMIN] Date question....

On Tue, May 20, 2003 at 18:08:22 -0500,
"Kovalcik, Mike A [ITS]" <mkoval01(at)sprintspectrum(dot)com> wrote:
> Hi,
>
> I'm trying to remove a date from table and it won't work. Basically I

> have an address book with birthdays and anniversaries and I want to
> remove an anniversary date from one of the entries. Every time I try
> it gives me "Bad date external representation". How do I remove a
> date from an entry?

The answer depends on how the date is represented. Why don't you show us
how the table is defined and the statement you tried, but that didn't
work.