• Jim@programming.dev
    link
    fedilink
    English
    arrow-up
    7
    ·
    8 months ago

    While it would be ideal to have all datetime fields in databases and other data stores be time zone aware, that is certainly not the case. Also, SQLite (and probably others) do not have great support for time zones and it’s recommended to store datetimes as UTC (typically unix timestamps).

    Deprecating utcnow was a good idea, but they should have replaced it with naive_utcnow. Oh well.

      • sugar_in_your_tea@sh.itjust.works
        link
        fedilink
        arrow-up
        8
        arrow-down
        1
        ·
        8 months ago

        Agreed. I’m an American and wish we could just all be on UTC. Yeah, my workday would start at like 0200, but that’s a sacrifice I’m willing to make.

        • Sigmatics@lemmy.ca
          link
          fedilink
          arrow-up
          2
          arrow-down
          1
          ·
          8 months ago

          Everyone on UTC sounds like such a great idea that would solve so many problems.

          Unfortunately humans are so dependent on daylight and the day night cycle that it will never work

          • twoframesperminute@mastodon.social
            link
            fedilink
            arrow-up
            4
            ·
            8 months ago

            @Sigmatics you can have everyone on the same time zone and still have different day/night cycles. It just means you have to get up at 14:00 and go to sleep at 5:00. The big problem with this is that the date-switch happens for everyone at the same time, which means you might have breakfast on Thursday and lunch on Friday. That makes it terribly inconvenient, and therefore probably unviable.

            • Sigmatics@lemmy.ca
              link
              fedilink
              arrow-up
              1
              arrow-down
              2
              ·
              8 months ago

              Yeah that’s kind of what I meant. People like their days to start at the same time every day. We are creatures of habit.

              • twoframesperminute@mastodon.social
                link
                fedilink
                arrow-up
                1
                ·
                8 months ago

                @Sigmatics Habits can be unlearned over a few generations. Doesn’t mean in becomes practical all if a sudden. It’s just messy to say “I’ll do this tomorrow” when “tomorrow” might mean “before I go to bed”.

                “See you Monday!”
                “Eh, before or after sleep on Monday?”

                It’s just not viable. It requires us to think differently about what a date is, returning the original issue: different people living at different dates.