Received: from srv.ctlno.com (216-175-179-80.client.dsl.net [216.175.179.80]) by hub.org (8.10.1/8.10.1) with ESMTP id e6AIIXW78099 for ; Mon, 10 Jul 2000 14:18:33 -0400 (EDT) Received: by SRV with Internet Mail Service (5.5.1960.3) id ; Mon, 10 Jul 2000 13:15:47 -0500 Message-ID: <183FA749499ED311B6550000F87E206C0F206B@SRV> From: Shalini shikha To: "'pgsql-sql@postgresql.org'" Subject: problem with date Date: Mon, 10 Jul 2000 13:15:45 -0500 MIME-Version: 1.0 X-Mailer: Internet Mail Service (5.5.1960.3) Content-Type: text/plain X-Archive-Number: 200007/104 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