I'm unclear on your task, but maybe this function will help: http://dev.mysql.com/doc/refman/5.1/en/date-and-time-functions.html#function_str-to-date
(It is confusing to have "dato" as both a column name and an alias.) > -----Original Message----- > From: Karl-Arne Gjersøyen [mailto:karlar...@gmail.com] > Sent: Wednesday, July 24, 2013 7:02 AM > To: MySQL Mailinglist > Subject: From DATE_FORMAT and back to origin date in mysql date column > > SELECT DATE_FORMAT(dato, '%e/%c/%Y') AS dato FROM transportdokument WHERE > dato >= '2013-07-20' AND dato <= '2013-07-24' GROUP BY dato DESC is > working perfect in my PHP file. > > But I need to transfer the date back from my norwegian formatted date to > the origin date format in WHERE dato >= '$standard_date_format'; > > What need I do to fix this? > > Thanks for your time and help to learn me programming! > > Karl -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql