Postgres Pro
Downloads
Home   >   mailing lists

Re: [GENERAL] Empty date field ! - Mailing list pgsql-general

From Peter Eisentraut
Subject Re: [GENERAL] Empty date field !
Date
Msg-id Pine.LNX.4.10.9907061853540.518-100000@saxony.pathwaynet.com
Whole thread Raw
In response to Empty date field !  ("Erik Colson" <beaver@glo.be>)
List pgsql-general
Tree view 
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.

pgsql-general by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: [GENERAL] one problem
Next
From: "Jackson, DeJuan"
Date:
Subject: RE: Fw: Re[2]: [GENERAL] Joins and links