Hi, I think the problem is the double quote you use. Try a single quote e.g.:
update yourtable set birthdate='200-01-01' where ... This man must be a very old one... :) I tried it using timestamp not date, but I think it should work as well. bye, -- cs. -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Pablo Digonzelli Sent: Tuesday, December 21, 2004 12:41 AM To: [EMAIL PROTECTED] Subject: [SQL] Date datatype hi all, Ca anyone send me an example how to update a date datatype? for example update table set birthdate = "200-01-01" doesnt work. TIA Pablo ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED] -- No virus found in this incoming message. Checked by AVG Anti-Virus. Version: 7.0.296 / Virus Database: 265.6.0 - Release Date: 2004.12.17. -- No virus found in this incoming message. Checked by AVG Anti-Virus. Version: 7.0.296 / Virus Database: 265.6.0 - Release Date: 2004.12.17. -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.296 / Virus Database: 265.6.0 - Release Date: 2004.12.17. -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.296 / Virus Database: 265.6.0 - Release Date: 2004.12.17. ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings
