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.
15 Comments
LordTrychon@sh.itjust.works · 15 pts · 304d
Maybe it's just too late and I'm too tired... but how is this DESC?
Cevilia@lemmy.blahaj.zone · 11 pts · 304d
tias@discuss.tchncs.de · 9 pts · 304d
But... why would you place them anticlockwise when the hands move in a clockwise direction
Cevilia@lemmy.blahaj.zone · 7 pts · 304d
tias@discuss.tchncs.de · 4 pts · 304d
Probably to make them appear right in clockwise order! Sometimes two wrongs make a right. Except when lexical ordering is used.
racketlauncher831@lemmy.ml · 5 pts · 304d
Isn't the word counter-clockwise?
porous_grey_matter@lemmy.ml · 9 pts · 304d
It's an American/British English difference
SCmSTR@lemmy.blahaj.zone · 3 pts · 304d
Til
Klear@quokk.au · 4 pts · 304d
Widdershins.
Cevilia@lemmy.blahaj.zone · 1 pts · 304d
HelloRoot@lemy.lol · 3 pts · 304d
You can learn something new every day.
MajinBlayze@lemmy.world · 6 pts · 304d
It's either extremely successful ragebait, or op thinks "desc" means "sort as a string"
MachineFab812@discuss.tchncs.de · 7 pts · 304d
Thanks, I hate it. I hate it BECAUSE I get it, to be clear. F'ing digits ...
sepi@piefed.social · 5 pts · 304d
It makes so much more sense this way.
AngryishHumanoid@lemmy.world · 4 pts · 304d
You sick son of a bitch.
untorquer@lemmy.world · 4 pts · 303d
I'm more bothered by the hour and minute hands having the same length.
Edit: make the minute hand shorter to make it worse
Fedizen@lemmy.world · 4 pts · 304d
Duodecimal clock > this. See you at B:00
poolhelmetinstrument@lemmy.world · 3 pts · 304d
luciferofastora@feddit.org · 2 pts · 303d
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.
Unknown_0671@lemmy.blahaj.zone · 1 pts · 304d