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?
[ Parent
| on HN ]
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.