Thread: problem with date

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

Try NULL rather than ''.  '' is not a null in postgres.


----- Original Message ----- 
From: Shalini shikha <shalini@ctlno.com>
To: <pgsql-sql@postgresql.org>
Sent: Monday, July 10, 2000 3:15 PM
Subject: [SQL] problem with date


> 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