Im have a Time field that im using to sort the records chronologically. Im storing the 12pm-24hr time as 00hr, since there isnt a real time of 24hr.
So, the problem is that when i Order the info by the time field the 00hr records appear at the start of the list instead that at the end (after the 11:59pm). I want them at the end because im using them as the End of the day, not the start of one.
Im ordering the field with this:
What can i do to fix this?
ORDER BY coalesce(time, 24)
Should i be storing the 12pm as 24hr? (i tried that, but the order by showed another value for the 24hr time)