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:[EMAIL PROTECTED]]
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 !
