Hello Javier, > I am developing an aplication where I need format the date for inserting > into mySQL.
=what language is your application written in? =dn > With DATE_FORMAT I can format the mySQL date to "my date", but I haven't > found a good way to format "my date" to the mySQL date. > > My format is 'dd-mm-yyyy' and to convert it to 'yyyy-mm-dd' I'm using > the next sequence: > > SELECT DATE_FORMAT( > CONCAT( > SUBSTRING_INDEX('03-05-2002', '-', -1), > '-', > SUBSTRING_INDEX(SUBSTRING_INDEX('03-05-2002', '-', 2), > '-', -1), > '-', > SUBSTRING_INDEX('03-05-2002', '-', 1)), > '%Y-%m-%d' ); > > I have searched in the manual, the list and in the DuBois' book, but I > haven't found a single function to parse my date to the mySQL date. Is > that rigth? Is there no function to parse from any date to the mySQL > date? > > Regards > > Javier > > > > --------------------------------------------------------------------- > 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