> Adding a month with + INTERVAL '1 months' is timezone-dependent. If your product operates in UTC, you must ensure the timezone is in UTC before adding a month with <timestamptz_column> AT TIME ZONE 'UTC' + INTERVAL '1 months'.... but now the result is a timestamp, not a timestamptz.
Different take. Maybe the mistake is believing you can add "1 month" to anything and expecting your intuition to be worth anything.
ekjhgkejhgk · · focus · HN ↗
Different take. Maybe the mistake is believing you can add "1 month" to anything and expecting your intuition to be worth anything.