Aravind, MySQL stores all dates as YYYY-MM-DD, if you must use MM/DD/YYYY then you can store it as a string.
The best method would be to let MySQL store the date as YYYY-MM-DD and use: select date_format(mydate, '%m/%d/%Y'); That will return mydate as "MM/DD/YYYY". =S. On Tue, 26 Feb 2002, S Aravind wrote: > 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 > --------------------------------------------------------------------- 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