Empty date field !

On Tue, 6 Jul 1999, Erik Colson wrote:

Hello !

I'm desperately searching how to UPDATE a date-field with an empty value ?

I really just want to clear a date field !

UPDATE table SET field_of_type_date = NULL [ WHERE condition ];

--
Peter Eisentraut
PathWay Computing, Inc.

I'm desperately searching how to UPDATE a date-field with an empty
value ?

use escape : \N (represents NULL)
Chris

--
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Christian Rudow E-Mail: Christian.Rudow@thinx.ch
ThinX networked business services Stahlrain 10, CH-5200 Brugg
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

UPDATE tablename SET datefieldname=NULL WHERE conditions=here;
�
I have had to code around this for some web applications I wrote. You can
assign datetime fields a NULL value, but you can't assign it an empty value
(''). Though, I didn't try "" instead of ''.
�
Greg
�

Gregory S. Youngblood
ext 2164
�
�

�

-----Original Message-----
From: Erik Colson [mailto:beaver@glo.be]
Sent: Tuesday, July 06, 1999 3:36 PM
To: Postgres-General
Subject: [GENERAL] Empty date field !

Hello !
�
I'm desperately searching how to UPDATE a date-field with an empty value ?
�
I really just want to clear a date field !
�
Please help
thanks !