• meekah
    link
    fedilink
    arrow-up
    1
    ·
    5 个月前

    Except this is order by DESC, so the ‘lowest’ value (Two) goes on index zero, the second lowest (Twelve) goes on index 1, etc.

    • Deebster@infosec.pub
      link
      fedilink
      English
      arrow-up
      1
      ·
      5 个月前

      But that’s not how clocks work - when the day starts on a normal clock it’s not 1 o’clock straight away, there’s an hour that happens first. The label is at the end of the hour’s segment.

      Think about it this way: when a new day begins, where are the clock hands?

      I did, the hour hand would be pointing at the (end of the) final hour, which is now eight. The minute hand’s position is a whole different discussion.

      • meekah
        link
        fedilink
        arrow-up
        1
        ·
        5 个月前

        The final hour is 8, and it would be pointing at the end of that. I don’t see your problem.

        • Deebster@infosec.pub
          link
          fedilink
          English
          arrow-up
          1
          ·
          5 个月前

          Again, that’s not how clocks work. The label on an analogue clock appears at the end of the hour segment. If the hour hand is halfway between two times, it’s half past the lower one.

          If, as you argue, two is at the top (like in OP’s picture), that means that when the day starts and the hour hand is pointing up then it’s already in the second hour. Half an hour later it would appear halfway between two and twelve which is an hour ahead of where it should be.