this post was submitted on 14 Dec 2023
928 points (99.2% liked)
xkcd
8791 readers
222 users here now
A community for a webcomic of romance, sarcasm, math, and language.
founded 1 year ago
MODERATORS
you are viewing a single comment's thread
view the rest of the comments
view the rest of the comments
Unix epoch time in UTC, making sure that your local offset and drift are current at the time of conversion to UTC...
i don't even care if its wrong, I just want the code to be readable.
You should care if it's wrong.
at the resolution of clock drift in milliseconds when I'm running reports that are, at most, only specific to the day?
Clock drift? No. Time zones? Probably.
not really time zones either outside the edge case where a data point exists within delta of midnight so that the time zone drift would result in a date change
Time zones change. Relative times without time zones don't make sense.