[prev in list] [next in list] [prev in thread] [next in thread]
List: mysql
Subject: RE: From DATE_FORMAT and back to origin date in mysql date column
From: Rick James <rjames () yahoo-inc ! com>
Date: 2013-07-24 17:49:41
Message-ID: 582AFBFC517D194489EF570FE21694CF14221E0C () GQ1-MB04-02 ! y ! corp ! yahoo ! com
[Download RAW message or body]
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:karlarneg@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
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic