Re: How to store empty to Date field ?

To update all existing records with empty values:
update table1
set datefield = null;

To insert an empty value into a new record:
insert into table1 (datefield) values (null);

Best of luck,

Andrew Gould

--- kingking <kingking(at)hknet(dot)com> wrote:
> Dear All,
>
> How to store empty to Date field ?
>
> Thanks
>
>
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 2: you can get off all lists at once with the
> unregister command
> (send "unregister YourEmailAddressHere" to
majordomo(at)postgresql(dot)org)

__________________________________________________
Do You Yahoo!?
Listen to your Yahoo! Mail messages from any phone.
http://phone.yahoo.com