AFAIK, you'll have to do the conversion before inserting the date into the database because MySQL does not support the MMDDYYYY format.
Regards, Al > -----Original Message----- > From: S Aravind [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, February 26, 2002 5:12 PM > To: [EMAIL PROTECTED] > Subject: Date Manipulation > > > Hi, > How can I insert a date in mm/dd/yyyy format in MySQL? > Meseems, it only supports yyyy-mm-dd format. As I'm a > beginner to MySQL, could anyone help me out and make > me solve this problem? > Thank you. > Aravind > > __________________________________________________ > Do You Yahoo!? > Everything you'll ever need on one web page > from News and Sport to Email and Music Charts > http://uk.my.yahoo.com > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail > <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php _________________________________________________________ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php