Clock, but its ORDER BY Hour DESC

submitted by

https://lemmy.world/pictrs/image/c308e109-b024-49c6-865c-acf4bcd3c2bb.png

Clock, but its ORDER BY Hour DESC
19
129

Log in to comment

Hot Top New Old

Maybe it’s just too late and I’m too tired… but how is this DESC?

 reply
14
edited

It has ORDER BY Hour DESC, results placed anticlockwise?

 reply
11

But… why would you place them anticlockwise when the hands move in a clockwise direction

 reply
9

Why would it have them in descending order in the first place? Nothing of this makes sense!

 reply
7
edited

Probably to make them appear right in clockwise order! Sometimes two wrongs make a right. Except when lexical ordering is used.

 reply
4

It’s either extremely successful ragebait, or op thinks “desc” means “sort as a string”

 reply
6

Thanks, I hate it. I hate it BECAUSE I get it, to be clear. F’ing digits …

 reply
7

Duodecimal clock > this. See you at B:00

 reply
4

It makes so much more sense this way.

 reply
4

No need for -n -r flags on the sort, looks good.

 reply
3
edited

I’m more bothered by the hour and minute hands having the same length.

Edit: make the minute hand shorter to make it worse

 reply
3

I work with a Data Warehouse that has a date table where the month is a text column. No, I don’t mean the name, I mean the month number. It’s a text. If I sort by month, I get this exact result.

It’s not a huge issue, really, but pissed me off when I finally realised why my shit looks all wrong.

 reply
2
Insert image