Eduardo Use the format 'yyyy-mm-dd' instead
By the way, there is an excellent manual on http://www.mysql.com including all the field types and formats Freddie -----Original Message----- From: Eduardo Melo [mailto:[EMAIL PROTECTED] Sent: Sonntag, 26. Oktober 2003 16:15 To: [EMAIL PROTECTED] Hi All ! I have a datetime field in a table. When I use insert into table (aniversary) values ('24/10/2003'). The date is save as 20/10/2024. I am using dd/mm/yyyy What can I do to save the date correctely ? best regards, Eduardo F. Melo _________________________________________________________________ MSN Messenger: converse com os seus amigos online. http://messenger.msn.com.br -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]