this post was submitted on 05 Nov 2025
169 points (97.7% liked)

Programmer Humor

27193 readers
1127 users here now

Welcome to Programmer Humor!

This is a place where you can post jokes, memes, humor, etc. related to programming!

For sharing awful code theres also Programming Horror.

Rules

founded 2 years ago
MODERATORS
Feyter@programming.dev
anzo@programming.dev
BurningTurtle@programming.dev
pylapp@programming.dev
169
Clock, but its ORDER BY Hour DESC (infosec.pub)
submitted 8 hours ago by cm0002 to c/programmer_humor@programming.dev
17 comments fedilink hide all child comments
top 17 comments
sorted by: hot top controversial new old
[–] zr0@lemmy.dbzer0.com 9 points 2 hours ago

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

[–] jet@hackertalks.com 3 points 2 hours ago (1 children)

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

[–] zr0@lemmy.dbzer0.com 2 points 1 hour ago (1 children)

Sure. No one ever in this entire world ever did a int(“0200”), because it is insane to represent numbers as actual numbers. I am so glad that military invented a standard working with any algorithm.

[–] sp3ctr4l@lemmy.dbzer0.com 1 points 32 minutes ago* (last edited 30 minutes ago)

I mean, I hear you, but to be fair, I think the military has been using that kind of a timing convention since before computing even really existed.

... We did more or less invent modern computers, initially, to compute artillery ranging tables.

I'm pretty sure that predates even the concept of ... a string vs int data type.

[–] Senseless@feddit.org 8 points 3 hours ago (1 children)

Thanks, I hate it.

[–] Barbarian@sh.itjust.works 5 points 3 hours ago (2 children)

Came to the comments to add exactly this. Am I predictable, or is this just the natural reaction to this image?

[–] llii@discuss.tchncs.de 2 points 2 hours ago

It is, I wanted to post this exact comment, too.

[–] Senseless@feddit.org 4 points 3 hours ago

Yes.

[–] getFrog@piefed.social 1 points 2 hours ago

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!

[–] MadhuGururajan@programming.dev 4 points 4 hours ago (1 children)

I wonder how it would look with excel sort

[–] sp3ctr4l@lemmy.dbzer0.com 1 points 36 minutes ago

Probably a bunch of error messages relating to improperly executed macro scripts, failed external api calls, and maybe copilot demanding you put all your documents into one drive... and also somehow the same 'hey, do you have a moment?' Teams message from one person, but somehow on 2 or 3 different versions of Teams, simultaneously.

[–] RogueBanana@piefed.zip 24 points 7 hours ago

Isn't it ascending? Alphabetically I mean.

[–] sunoc@sh.itjust.works 23 points 8 hours ago* (last edited 8 hours ago) (1 children)

Still way better than the best LLMs can do

[–] otacon239@lemmy.world 8 points 3 hours ago* (last edited 3 hours ago) (1 children)

~~Kimi and Deepseek both seem to do a decent job.~~

Something funky is going on. They’re somewhat random each time I refresh. Sometimes they work, sometimes they don’t.

[–] kambusha@sh.itjust.works 3 points 2 hours ago

Click on the question mark for an explanation

[–] Jeeve65@ttrpg.network 20 points 8 hours ago (1 children)

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

[–] smeg@feddit.uk 1 points 59 minutes ago

It's usually IIII on clocks