News for hackers. Stuff that matters.

A comment on PostgreSQL – Don't Do This. Parent comment

Re:PostgreSQL – Don't Do This by m_0x on Thursday June 01, 2023 @11:29AM (#36152538)
> if you select a timestamp value Postgres can convert it from UTC to the timezone you want

I dread timestamp issues. Hard to understand what happens and how to fix them.

You mention "if necessary". How does postgres knows if a conversion is necessary?

[ Parent | on HN ]
Re:PostgreSQL – Don't Do This by paulryanrogers on Saturday June 03, 2023 @09:22AM (#36176470)
If the value has a TZ offset it'll know. If it doesn't but the session TZ differs from UTC then it'll know. With non-TZ timestamp both cases could store the wrong timestamp and it might be impossible to catch or correct without the original data or more context.
[ Parent | on HN ]