problem with date

From: Shalini shikha <shalini(at)ctlno(dot)com>
To: "'pgsql-sql(at)postgresql(dot)org'" <pgsql-sql(at)postgresql(dot)org>
Subject: problem with date
Date: 2000-07-10 18:15:45
Message-ID: 183FA749499ED311B6550000F87E206C0F206B@SRV
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

How can I insert/update a null value in a date field. If a try a sql
statement like the following:

update customer set birth_date = '' where cust_id like 'xyz', I get a
error message saying: Bad date representation.

Thanks in advance,
Shalini

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message DalTech - Continuing Technical Education 2000-07-10 18:17:38 Re: problem with date
Previous Message Ed Loehr 2000-07-10 18:08:58 Re: SERIAL type does not generate new ID ?