| Re: How to loop through the dates? [message #186134 is a reply to message #186119] |
Sun, 15 June 2014 23:14   |
Lew Pitcher
Messages: 60
Registered: April 2013
Karma:
|
Member |
|
|
On Sunday 15 June 2014 13:40, in comp.lang.php, "Denis McMahon"
<denismfmcmahon(at)gmail(dot)com> wrote:
> On Sun, 15 Jun 2014 12:11:01 -0400, richard wrote:
>
>> Data is ordered by date.
>
> See, this is where the richard database design starts to bite the richard
> arse.
>
> You are storing dates as a string representation of the date, so your
> "order by date" sql clause causes the data to be ordered according to the
> string collation for the relevant table.
>
> If you want the mysql rdbms to sort the data into date sequence, then you
> need to store the data as dates.
That's good advice (the best).
However, richard can get away with
SELECT * FROM table ORDER BY STR_TO_DATE(date,date_string_format);
That will convert his string dates to "real" dates for the purposes of
ordering the resultset rows, and should come out in ascending sequence by
calendar date.
http://dev.mysql.com/doc/refman/5.5/en/date-and-time-functions.html#functio n_str-to-date
[snip]
--
Lew Pitcher
"In Skills, We Trust"
PGP public key available upon request
|
|
|
|
Calendar
Search
Help
Members
Register
Login
Home
]