Обсуждение: Empty date field !

Поиск
Список
Период
Сортировка

Empty date field !

От
"Erik Colson"
Дата:
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 !

Re: [GENERAL] Empty date field !

От
Peter Eisentraut
Дата:
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.


Re: [GENERAL] Empty date field !

От
Christian Rudow
Дата:
> 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
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~