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.

[–] BeardedGingerWonder@feddit.uk 7 points 11 months ago (3 children)

Timezones are a disease and should be eradicated. I will die on this hill.

[–] sugar_in_your_tea@sh.itjust.works 6 points 11 months ago (1 children)

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 -1 points 11 months ago (1 children)

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 3 points 11 months ago (1 children)

@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 -2 points 11 months ago (1 children)

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 1 points 11 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.

[–] AlexWIWA@lemmy.ml 2 points 11 months ago

I agree. I hate timezones so much

[–] twoframesperminute@mastodon.social -4 points 11 months ago (1 children)

@BeardedGingerWonder will you adapt your time to be 7 hours later?

Thought so.

[–] BeardedGingerWonder@feddit.uk 2 points 11 months ago

You thought what?