Thread: 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
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~