Re: [SQL] problem with date

[DalTech - Continuing Technical Education]

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


----- Original Message ----- 
From: Shalini shikha <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
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