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 !

Reply via email to