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 !