Hello,
> > I am developing an aplication where I need format the date for > > inserting into mySQL. > > =what language is your application written in? > =dn The application is written in Java, but the problem is that the module where the dates for the DB are managed is an open source framework and I wouldn't like to touch that code. The framework provides a way to modify the dates from/to the database defining native database functions in a config file. Anyway, the problem is alredy solved, but I still have the dude if I there is a better solution. Regards Javier > > > > 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