Re: [SQL] Updating datetime fields with NULL values

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