To update all existing records with empty values: update table1 set datefield = null;
To insert an empty value into a new record: insert into table1 (datefield) values (null); Best of luck, Andrew Gould --- kingking <[EMAIL PROTECTED]> wrote: > Dear All, > > How to store empty to Date field ? > > Thanks > > > > > ---------------------------(end of > broadcast)--------------------------- > TIP 2: you can get off all lists at once with the > unregister command > (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED]) __________________________________________________ Do You Yahoo!? Listen to your Yahoo! Mail messages from any phone. http://phone.yahoo.com ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
