RE: [GENERAL] Empty date field !

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(at)glo(dot)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 !