Received: from aventurine.sge.net (aventurine.sge.net [152.91.14.25]) by hub.org (8.9.3/8.9.3) with ESMTP id RAA00871 for ; Tue, 16 Nov 1999 17:31:26 -0500 (EST) (envelope-from G.MacMinn@nca.gov.au) Received: from cadmium.sge.net (cadmium.sge.net [152.91.9.5]) by aventurine.sge.net (8.9.3/8.9.3) with ESMTP id JAA99707 for ; Wed, 17 Nov 1999 09:31:22 +1100 (EST) Received: (from uucp@localhost) by cadmium.sge.net (8.9.3/8.9.3) id JAA04022 for ; Wed, 17 Nov 1999 09:31:20 +1100 (EST) Received: from nodnsquery(10.1.2.11) by cadmium.sge.net via smap (V5.0) id xma003948; Wed, 17 Nov 99 09:31:11 +1100 Received: from amber (amber-int2.sge.net [10.1.2.254]) by kryptonite.sge.net (8.9.3/8.9.3) with SMTP id JAA79761 for ; Wed, 17 Nov 1999 09:31:10 +1100 (EST) Message-Id: X-Mailer: Novell GroupWise 5.2 Date: Wed, 17 Nov 1999 09:28:34 +1100 From: "Gary MacMinn" To: pgsql-sql@postgreSQL.org Subject: Updating datetime fields with NULL values Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Disposition: inline Content-Transfer-Encoding: 8bit X-MIME-Autoconverted: from quoted-printable to 8bit by hub.org id RAA00897 Morning All, Is it possible to clear a datetime field to NULL? If so, how? In trying an update (update test set d1='' where t1='Text2';) I get an error of Bad datetime external representation '' TIA, Gary MacMinn =============================================== Table = test +----------------------------------+----------------------------------+-------+ | Field | Type | Length| +----------------------------------+----------------------------------+-------+ | t1 | text | var | | d1 | datetime | 8 | +----------------------------------+----------------------------------+-------+