From: John Ziniti <ziniti@helix.mgh.harvard.edu>
To: SQL <pgsql-sql@postgreSQL.org>
Subject: Re: [SQL] Updating datetime fields with NULL values
Date: Tue, 16 Nov 1999 17:58:09 -0500
Message-ID: <3831E181.621187B9@helix.mgh.harvard.edu> (raw)
References: <s832757b.009@syd_aux.nca.gov.au>
Hey Gary,
Use the keyword NULL as your value:
pipeline=> create table testme (datetimetest datetime);
CREATE
pipeline=> insert into testme (datetimetest) values ('now');
INSERT 1509043 1
pipeline=> select * from testme;
datetimetest
----------------------------
Tue Nov 16 17:56:09 1999 EST
(1 row)
pipeline=> update testme set datetimetest=NULL;
UPDATE 1
pipeline=> select * from testme;
datetimetest
------------
(1 row)
Gary MacMinn wrote:
>
> 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 |
> +----------------------------------+----------------------------------+-------+
>
> ************
--
John Ziniti
Mass General Hospital
CVRC 149-4201
149 13th Street
Charlestown, MA 02129
tel (617) 726-4347
fax (617) 726-5806
ziniti@helix.mgh.harvard.edu
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: ziniti@helix.mgh.harvard.edu
Subject: Re: [SQL] Updating datetime fields with NULL values
In-Reply-To: <3831E181.621187B9@helix.mgh.harvard.edu>
References: <s832757b.009@syd_aux.nca.gov.au> <3831E181.621187B9@helix.mgh.harvard.edu>
* 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