Check your DATE format in your server variables... MySQL default date format is YYYY-MM-DD. You can change it, however until then, you have to use
update policies set renewdate = '2006/02/21' where polnumber = 'WRIM01002'; HTH, J.R. <snip> Hello. This is a frequently asked question. For example read these threads: http://lists.mysql.com/mysql/175324 http://lists.mysql.com/mysql/177730 -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET <___/ www.mysql.com </snip> -----Original Message----- From: Mark Mchugh [mailto:[EMAIL PROTECTED] Sent: Thursday, March 24, 2005 9:22 AM To: mysql list Subject: updating date fields using sql Hi, Dont know whats happening here i'm using the following SQL update policies set renewdate = '21/02/2006' where polnumber = 'WRIM01002'; but, when i update the databse, the date sets to the year 2021 ? i've prob done something daft...... please help if you can... MArk __________________________________ Do you Yahoo!? Yahoo! Small Business - Try our new resources site! http://smallbusiness.yahoo.com/resources/ -- MySQL Windows Mailing List For list archives: http://lists.mysql.com/win32 To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
smime.p7s
Description: S/MIME cryptographic signature