From: Gary MacMinn <G.MacMinn@nca.gov.au>
To: pgsql-sql@postgreSQL.org
Subject: Updating datetime fields with NULL values
Date: Wed, 17 Nov 1999 09:28:34 +1100
Message-ID: <s832757b.009@syd_aux.nca.gov.au> (raw)
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 |
+----------------------------------+----------------------------------+-------+
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-sql@postgresql.org
Cc: G.MacMinn@nca.gov.au
Subject: Re: Updating datetime fields with NULL values
In-Reply-To: <s832757b.009@syd_aux.nca.gov.au>
References: <s832757b.009@syd_aux.nca.gov.au>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox