pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
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



view thread (2+ messages)

Message-ID: <3831E181.621187B9@helix.mgh.harvard.edu>
Permalink:  ../3831E181.621187B9@helix.mgh.harvard.edu/
Also on:    postgresql.org/message-id/3831E181.621187B9@helix.mgh.harvard.edu

 · 

reply

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