# Pastebin 5wc8QmBD listenbrainz_ts=> SELECT t::timestamptz, t::timestamptz AT TIME ZONE 'Pacific/Fiji' FROM (VALUES ('2020-01-25T12:00:00Z'), ('2020-12-25T12:00:00Z'), ('2021-01-25T12:00:00Z'), ('2021-12-25T12:00:00Z'), ('2022- t | timezone ------------------------+--------------------- 2020-01-25 12:00:00+00 | 2020-01-26 00:00:00 2020-12-25 12:00:00+00 | 2020-12-26 01:00:00 2021-01-25 12:00:00+00 | 2021-01-26 00:00:00 2021-12-25 12:00:00+00 | 2021-12-26 00:00:00 2022-01-25 12:00:00+00 | 2022-01-26 00:00:00 2022-12-25 12:00:00+00 | 2022-12-26 01:00:00 (6 rows)