• Jim
    link
    English
    77 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.

      • @[email protected]
        link
        fedilink
        87 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.

        • @[email protected]
          link
          fedilink
          -17 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
            link
            fedilink
            47 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.

            • @[email protected]
              link
              fedilink
              -17 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
                link
                fedilink
                17 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.