skip to Main Content

Postgresql – Why is string literal '2021-02-16 09:00' without timezone information interpreted as `timestamp with time zone` with AT TIME ZONE?

set timezone = 'Asia/Ho_Chi_Minh'; I set times displayed to GMT+7. select '2021-02-16 09:00' AT TIME ZONE 'Asia/Singapore'; select '2021-02-16 09:00+06' AT TIME ZONE 'Asia/Singapore'; Output 2021-02-16 10:00:00 2021-02-16 11:00:00 Because AT TIME ZONE converts timestamp without time zone to timestamp…

VIEW QUESTION
Back To Top
Search