RE: From DATE_FORMAT and back to origin date in mysql date column

rsø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 >= '2

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_