this post was submitted on 03 Apr 2024
380 points (95.5% liked)
Programmer Humor
32563 readers
556 users here now
Post funny things about programming here! (Or just rant about your favourite programming language.)
Rules:
- Posts must be relevant to programming, programmers, or computer science.
- No NSFW content.
- Jokes must be in good taste. No hate speech, bigotry, etc.
founded 5 years ago
MODERATORS
you are viewing a single comment's thread
view the rest of the comments
view the rest of the comments
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_Yorkbecause God knows what 2030 will look like.And if timezone are abolished, or DST, that's even more reason to store the timezone name.