Received: from Alex2.cte.Dal.Ca (Alex2.cte.Dal.Ca [134.190.17.62]) by hub.org (8.10.1/8.10.1) with ESMTP id e6AIT5W00617 for ; Mon, 10 Jul 2000 14:29:06 -0400 (EDT) Received: from ghost (Ghost.cte.Dal.Ca [134.190.17.89]) by Alex2.cte.Dal.Ca (8.9.3/8.9.3) with SMTP id PAA30863; Mon, 10 Jul 2000 15:41:09 -0300 Message-ID: <003201bfea9b$93ad45a0$5911be86@cte.Dal.Ca> From: "DalTech - Continuing Technical Education" To: "Shalini shikha" Cc: "Pgsql-sql" References: <183FA749499ED311B6550000F87E206C0F206B@SRV> Subject: Re: problem with date Date: Mon, 10 Jul 2000 15:17:38 -0300 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.00.2615.200 X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2615.200 X-Archive-Number: 200007/105 Try NULL rather than ''. '' is not a null in postgres. ----- Original Message ----- From: Shalini shikha To: 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