I have a mysql db, with a timestamp(14) field.
When I do a sort on the db with an ORDER BY date DESC
It sorts it sorta funny..
If there was 4 entries in the DB for today, all with different times, it seems to work fine until the hour changes past noon.
So it would like this:
12:45
12:44
12:30
1:10 <-- I want this one on top.
What am I doing wrong?
When I do a sort on the db with an ORDER BY date DESC
It sorts it sorta funny..
If there was 4 entries in the DB for today, all with different times, it seems to work fine until the hour changes past noon.
So it would like this:
12:45
12:44
12:30
1:10 <-- I want this one on top.
What am I doing wrong?