Campfyre
  • Communities
  • Create Post
  • Create Community
  • heart
    Support Lemmy
  • search
    Search
  • Login
  • Sign Up
cm0002@infosec.pub to Programmer Humor@programming.dev · 4 days ago

Clock, but its ORDER BY Hour DESC

infosec.pub

message-square
29
fedilink
365

Clock, but its ORDER BY Hour DESC

infosec.pub

cm0002@infosec.pub to Programmer Humor@programming.dev · 4 days ago
message-square
29
fedilink
alert-triangle
You must log in or # to comment.
  • Sunoc@sh.itjust.works
    link
    fedilink
    arrow-up
    43
    ·
    edit-2
    4 days ago

    Still way better than the best LLMs can do

    • otacon239@lemmy.world
      link
      fedilink
      arrow-up
      13
      ·
      edit-2
      4 days ago

      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
        link
        fedilink
        arrow-up
        8
        ·
        4 days ago

        Click on the question mark for an explanation

  • RogueBanana@piefed.zip
    link
    fedilink
    English
    arrow-up
    35
    ·
    4 days ago

    Isn’t it ascending? Alphabetically I mean.

  • wischi@programming.dev
    link
    fedilink
    arrow-up
    17
    arrow-down
    1
    ·
    edit-2
    4 days ago

    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/

    • RiQuY@lemmy.zip
      link
      fedilink
      arrow-up
      3
      arrow-down
      1
      ·
      4 days ago

      Your clock goes backwards.

      • wischi@programming.dev
        link
        fedilink
        arrow-up
        5
        ·
        4 days ago

        That’s intended. Look at the second hand for a minute. It goes 1, 2, 3, etc. like on a real clock but the numbers are distributed differently. That’s also why the hands sometimes have to move faster to reach their target in time. It goes (backwards) if it’s closer.

  • Jeeve65@ttrpg.network
    link
    fedilink
    arrow-up
    23
    ·
    4 days ago

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

    • smeg@feddit.uk
      link
      fedilink
      English
      arrow-up
      2
      ·
      4 days ago

      It’s usually IIII on clocks

    • wischi@programming.dev
      link
      fedilink
      arrow-up
      1
      ·
      4 days ago

      Here you are: https://jsfiddle.net/2o97k6vz/6/

  • gwl@lemmy.blahaj.zone
    link
    fedilink
    English
    arrow-up
    9
    ·
    edit-2
    3 days ago

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

    Edit: couldn’t find one, made one

    [email protected]

    • ForeverComical@lemmy.ca
      link
      fedilink
      arrow-up
      2
      ·
      4 days ago

      Then you’ll love this video https://youtu.be/TOzEnwl7LkA

      • gwl@lemmy.blahaj.zone
        link
        fedilink
        English
        arrow-up
        1
        ·
        3 days ago

        Makes me think of the https://neal.fun/ one for passwords

        • ramjambamalam@lemmy.ca
          link
          fedilink
          English
          arrow-up
          2
          ·
          3 days ago

          Kitboga has some videos where he integrates Neal’s password game into a fake bank password reset UI, and gets the scammers to play the game. It’s one of the GOAT scambait videos.

  • Australis13@fedia.io
    link
    fedilink
    arrow-up
    4
    ·
    3 days ago

    Somebody used the wrong data type for the Hour column…

    • AnotherPenguin@programming.dev
      link
      fedilink
      English
      arrow-up
      1
      ·
      3 days ago

      There are no wrong data types in javascript :D

      • YellowTraveller@lemmy.zip
        link
        fedilink
        arrow-up
        4
        ·
        3 days ago

        There are no right data type in javascript*

  • zr0@lemmy.dbzer0.com
    link
    fedilink
    English
    arrow-up
    11
    arrow-down
    1
    ·
    4 days 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

    • gwl@lemmy.blahaj.zone
      link
      fedilink
      English
      arrow-up
      1
      ·
      4 days ago

      That depends on language

      • optissima@lemmy.ml
        link
        fedilink
        arrow-up
        1
        ·
        4 days ago

        Finally a truly localised time

        • gwl@lemmy.blahaj.zone
          link
          fedilink
          English
          arrow-up
          1
          ·
          4 days ago

          I meant programming language, but yeah also true

  • jlow (he / him)@discuss.tchncs.de
    link
    fedilink
    arrow-up
    4
    ·
    4 days ago

    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

  • MadhuGururajan@programming.dev
    link
    fedilink
    English
    arrow-up
    5
    ·
    4 days ago

    I wonder how it would look with excel sort

    • sp3ctr4l@lemmy.dbzer0.com
      link
      fedilink
      English
      arrow-up
      2
      ·
      4 days 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.

  • jet@hackertalks.com
    link
    fedilink
    English
    arrow-up
    4
    ·
    4 days ago

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

    • zr0@lemmy.dbzer0.com
      link
      fedilink
      English
      arrow-up
      3
      arrow-down
      1
      ·
      4 days ago

      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
        link
        fedilink
        English
        arrow-up
        2
        ·
        edit-2
        4 days 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.

        • Frezik@lemmy.blahaj.zone
          link
          fedilink
          English
          arrow-up
          1
          ·
          edit-2
          4 days ago

          Depends on what you call a “computer”. The first electronic calculating machine sold by the company now known as IBM was for the census, and it was prior to WWI.

          Edit: we need to fight back on this idea that the military drives technological innovation. That’s only true because of the shitty values our society has.

          • optissima@lemmy.ml
            link
            fedilink
            arrow-up
            1
            ·
            4 days ago

            The German one?

Programmer Humor@programming.dev

programmer_humor@programming.dev

Subscribe from Remote Instance

Create a post
You are not logged in. However you can subscribe from another Fediverse account, for example Lemmy or Mastodon. To do this, paste the following into the search field of your instance: [email protected]

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

  • Keep content in english
  • No advertisements
  • Posts must be related to programming or programmer topics
Visibility: Public
globe

This community can be federated to other instances and be posted/commented in by their users.

  • 1.71K users / day
  • 4.06K users / week
  • 8.33K users / month
  • 18.5K users / 6 months
  • 1 local subscriber
  • 27.2K subscribers
  • 1.87K Posts
  • 68.1K Comments
  • Modlog
  • mods:
  • Feyter@programming.dev
  • adr1an@programming.dev
  • BurningTurtle@programming.dev
  • Pierre-Yves Lapersonne@programming.dev
  • BE: 0.19.7
  • Modlog
  • Legal
  • Instances
  • Docs
  • Code
  • join-lemmy.org