←back to thread

Debian 13, Postgres, and the US/* time zones

(rachelbythebay.com)
283 points move-on-by | 1 comments | 12 Sep 25 02:33 UTC | HN request time: 0s | source
Show context
reactordev ◴[12 Sep 25 12:23 UTC] No.45221373[source]▶
Ooofff. The two difficult things in software engineering, naming, and timestamps.

This hit me in the early 2000s and now everything I do is in UTC. All dates, timestamps, everything, UTC. If you want to look at a local window in time, convert the window to a utc start and end date and search. When viewing, use a js function to translate the utc date to a local one to print. The mental gymnasium of local to utc to local again…

replies(2): >>45221583 #>>45222947 #
dotancohen ◴[12 Sep 25 12:53 UTC] No.45221583[source]▶

  > The two difficult things in software engineering, naming, and timestamps.
And off-by-one errors. The two most difficult things in software engineering: naming things, timestamps, and off-by-one errors.
replies(1): >>45225028 #
1. TheNewsIsHere ◴[12 Sep 25 18:23 UTC] No.45225028[source]▶
I see what you did there.