Still way better than the best LLMs can do

Isn't it ascending? Alphabetically I mean.

You mean I, II, III, IV, IX, V, VI, VII, VIII, X, XI, XII

Order by string desc would be Z-A ordering, or 9-0

ORDER BY str(Hour) DESC: 9, 8, 7, 6, 5, 4, 3, 2, 12, 11, 10, 1

ORDER BY int(Hour) DESC: 12, 11, 10, 9, 8, 7, 6, 5, 4, 3, 2, 1

Makes me wonder if there's an equivalent of /r/BadUXBattles loved that Reddit

Edit: couldn't find one, made one

!baduibattles@lemmy.blahaj.zone

Because an image is a bit to lazy IMHO for "prgrammer" humor. I programmed a clock that actually works. Have fun 🤣

https://jsfiddle.net/gjpwf5oq/2/

Btw: you can change the order of the clock-face if you want.

Update: Supports arbitrary text now (example roman numerals): https://jsfiddle.net/2o97k6vz/6/

Update: And with Months because why not 🤣 https://jsfiddle.net/2o97k6vz/7/

I wonder how it would look with excel sort

Somebody used the wrong data type for the Hour column...

This is why the military uses 03 hundred hours... Makes things clear, and sortable regardless of your algorithm

Now do a clock version of the weird American date format, mm/dd/yyyy? Maybe it has to be digital?

mm:ss:hh? But obviously dont use 24h

Print that header onto the dial in a monospace font and you've got yourself an extremely marketable product. Perfect thing to bring to a white elephant gift exchange at an IT Company!