this post was submitted on 03 Apr 2024
226 points (94.8% liked)

Programmer Humor

32380 readers
914 users here now

Post funny things about programming here! (Or just rant about your favourite programming language.)

Rules:

founded 5 years ago
MODERATORS
 
you are viewing a single comment's thread
view the rest of the comments
[โ€“] ShortFuse 2 points 7 months ago* (last edited 7 months ago) (1 children)

Timestamp in UTC

But for time of day, use local time and store separate column with the timezone name. Don't use timezone offsets since that doesn't work with DST. You're better off with something like America/New_York because God knows what 2030 will look like.

And if timezone are abolished, or DST, that's even more reason to store the timezone name.

[โ€“] [email protected] 2 points 7 months ago

Yes that's true, I just go by whatever ISO standard