PostgreSQL AT Time Zone转换异常?实为DBeaver问题
UTC转美国东部标准时间(EST)在夏令时切换时段的异常排查问题
我正在将UTC时间转换为美国东部标准时间(EST),但在2023年3月12日的“夏令时提前”时段发现异常:使用US/Eastern转换为东部现行时间正常,但用EST、Etc/GMT+5、America/Cancun三种方式转换第8行数据时,本该得到东部标准时间(UTC-5)的2023-03-12 02:00:00.000,却显示为2023-03-12 03:00:00.000,该行前后时段转换均正常。我不确定是操作有误、理解偏差还是存在bug,恳请协助排查。
查询SQL如下:
select start_time_utc as utc , CAST(start_time_utc AT TIME ZONE 'UTC' AT TIME ZONE 'US/Eastern' AS timestamp) AS east_prevailing , CAST(start_time_utc AT TIME ZONE 'UTC' AT TIME ZONE 'EST' AS timestamp) AS eastern_stabdard_v1 , CAST(start_time_utc AT TIME ZONE 'UTC' AT TIME ZONE 'Etc/GMT+5' AS timestamp) AS eastern_stabdard_v2 , CAST(start_time_utc AT TIME ZONE 'UTC' AT TIME ZONE 'America/Cancun' AS timestamp) AS eastern_stabdard_v3 from public.crr_obligation_hourly where unit_id =1 and extract(month from start_time_utc)=3 and extract(day from start_time_utc)=12 order by 1
查询结果截图:
更新:经排查,该问题实际由DBeaver导致,我将在下方发布解答。
内容的提问来源于stack exchange,提问作者sguo
相关产品推荐
相关产品推荐

