TGViewer
Programming Programming @programmingreddit · 900 subscribers
Post #13466 19
Postgres AT TIME ZONE 'UTC' does NOT do what you think it does
https://bookofrevenue.com/blog/6ab81e9a97a13f0001f7e4e1/postgres-at-time-zone-u-does-not-do-what-you-think-it-does

https://redd.it/1wrc4sh
@programmingreddit
Book of Revenue Postgres AT TIME ZONE 'UTC' does NOT do what you think it does And why you may need to repeat AT TIME ZONE 'UTC' twice. Postgres has these 2 timestamp types: timestamp and timestamptz. timestamp doesn't contain the timezone information. Technically, it doesn't represent a time in the real world. Thinking about it deeply…
Open in Telegram All posts from @programmingreddit
More from @programmingreddit
  1. Sep 26, 2026Optimizing a Lock-Free Ring Buffer https://david.alvarezrosa.com/posts/optimizing-a-lock-f…
  2. Sep 25, 2026Microservices are organizational debt disguised as architecture. https://martinfowler.com/…
  3. Sep 25, 2026We still maintain a development tool first released in 1993. Here’s what 30+ years of back…
  4. Sep 24, 2026How GCC and Clang performance changed over 10 years: my experiment https://medium.com/@kos…
  5. Sep 24, 2026Railway-Oriented Programming https://kciter.so/posts/railway-oriented-programming/en/ http…
  6. Sep 23, 2026We ported the original Doom to SQL https://cedardb.com/blog/sqldoom/ https://redd.it/1wo7a…
Threads Profile ViewerView any public Threads profile without an account.Open ThreadLook →Writing with AI? Make it sound human.Metric37 rewrites AI drafts so they read naturally. Free AI detector, 1,500 words free.Try Metric37 →