Date/time sort not working.

admin

Administrator
Staff member
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?
 
Back
Top