• meekah@discuss.tchncs.de
    link
    fedilink
    arrow-up
    1
    ·
    edit-2
    5 hours ago

    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
      ·
      edit-2
      4 hours ago

      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.

        • Deebster@infosec.pub
          link
          fedilink
          English
          arrow-up
          1
          ·
          3 hours ago

          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.