this post was submitted on 28 May 2024
114 points (96.0% liked)

Programming

16975 readers
1288 users here now

Welcome to the main community in programming.dev! Feel free to post anything relating to programming here!

Cross posting is strongly encouraged in the instance. If you feel your post or another person's post makes sense in another community cross post into it.

Hope you enjoy the instance!

Rules

Rules

  • Follow the programming.dev instance rules
  • Keep content related to programming in some way
  • If you're posting long videos try to add in some form of tldr for those who don't want to watch videos

Wormhole

Follow the wormhole through a path of communities [email protected]

founded 1 year ago
MODERATORS
[email protected]
[email protected]
[email protected]
114
I Don't Trust My Own Code (lackofimagination.org)
submitted 3 months ago by [email protected] to c/[email protected]
38 comments fedilink hide all child comments
you are viewing a single comment's thread
view the rest of the comments
[–] [email protected] 33 points 3 months ago (2 children)

Me neither buddy, me neither...

Falsehoods About Time: ... Time always moves forwards.

I had to learn this the hard way... I was working at a platform that pulled measurements from sensors. The sensors did not declare the timezone for the timestamps of the measurement and the platform broke down twice after daylight saving. The first time there were duplicated records which caused conflicts and the second one we weren't handling impossible timestamps.

[–] [email protected] 23 points 3 months ago (2 children)

I had a client whose clock was just a few milliseconds behind the server's, but due to timezone crap one hour in the past. And the signature was valid for one hour.

If the network just happened to be too congested, the validation failed. The next request went through just fine. Took us forever to find out.

[–] [email protected] 3 points 3 months ago (1 children)

I sure do hate time zones.

[–] [email protected] 2 points 3 months ago

So say we all

[–] [email protected] 3 points 3 months ago (1 children)

I don't really get why people use any time other than ms/seconds since the epoch for anything other than displaying that time to the end user. Having time just be a single number with no time zone shenanigans makes writing logic like that so much easier.

[–] [email protected] 2 points 3 months ago

Epochs aren't that simple either.

First of all, local time can be relevant, so you have to store timezone information somewhere anyway.

Epochs are also somewhat iffy in regards to leap years or seconds.

And finally: write me an SQL to retrieve all entries submitted in 2022 using just epochs.

Timezones are annoying as fuck, don't get me wrong, but simply ignoring them isn't a solution either.

[–] [email protected] 5 points 3 months ago* (last edited 3 months ago)