cm0002@infosec.pub to Programmer Humor@programming.dev · 26 days agoClock, but its ORDER BY Hour DESCinfosec.pubexternal-linkmessage-square29fedilinkarrow-up1381arrow-down113
arrow-up1368arrow-down1external-linkClock, but its ORDER BY Hour DESCinfosec.pubcm0002@infosec.pub to Programmer Humor@programming.dev · 26 days agomessage-square29fedilink
minus-squarezr0@lemmy.dbzer0.comlinkfedilinkEnglisharrow-up11arrow-down1·26 days agoOrder 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
minus-squaregwl@lemmy.blahaj.zonelinkfedilinkEnglisharrow-up1·26 days agoI meant programming language, but yeah also true
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, 1ORDER BY int(Hour) DESC: 12, 11, 10, 9, 8, 7, 6, 5, 4, 3, 2, 1That depends on language
Finally a truly localised time
I meant programming language, but yeah also true