News for hackers. Stuff that matters.
Re:Postgres AT TIME ZONE 'UTC' does NOT do what you think it... by estetlinus on Monday September 28, 2026 @05:28AM (#49875508)
Makes me wonder what kind of footgun we are talking about here — is it classic, smoking, standard or vanilla?
Re:Postgres AT TIME ZONE 'UTC' does NOT do what you think it... by officialchicken on Monday September 28, 2026 @05:58AM (#49875695)
Rookie pseudo-footgun - assumed skill exceeds capability error - usually accompanied with blameshifting pronunciation as demonstrated here. Anyone familiar with UTC/tz from another platform (e.g. excel) would be mostly immune or able to quickly identify and remedy.
Re:Postgres AT TIME ZONE 'UTC' does NOT do what you think it... by TeMPOraL on Monday September 28, 2026 @07:20AM (#49876327)
People who handle this footgun properly tend to come from two groups:

- Those with safety training for this class of foot-pointed firearms, who know how dumb shit looks like and that they should not do it;

- Those with officer training who are able to recognize the higher-level categories, and take principled approach to safety - e.g. recognizing that "date", "timestamp, "duration", "time of day", "time of week", etc. are different concepts and should not be mixed.