Hi, i got a minor problem … trying to sort a few things out.
I’m saving a time stamp in my DB, where the hours and minutes are stored in eachh their own row like:
Hours in column: timehh
Minutes in column: timemm
My problem is when i sort it then it’s not sorting right …
The way it sorts now:
08:00
09:00
08:10
08:20
08:05
The way i want it to sort
08:00
08:05
08:10
08:20
09:00
This i my query:
“SELECT * FROM timedate ORDER BY timehh AND timemm ASC”
Anyone got a quick fix?
I can post source if needed…