I'm a little confused by trying to get the time at a different timezone, formerly UTC-6: template1=# select '2019-10-22 16:00:00' at time zone 'Europe/Rome' as my_time , '2019-10-22 16:00:00' at time zone 'America/Denver' as what_should_be, '2019-10-22 16:00:00' at time zone 'UTC-6' as utc_minus_6, '2019-10-22 16:00:00' at time zone 'UTC+6' as utc_plus_6; -[ RECORD 1 ]--+-------------------- my_time | 2019-10-22 16:00:00 what_should_be | 2019-10-22 08:00:00 utc_minus_6 | 2019-10-22 20:00:00 utc_plus_6 | 2019-10-22 08:00:00 Now, the denver time should be 8:00, which is what is reported as UTC+6, but as far as I know Denver is UTC-6 (in daylight saving). What am I missing here? Thanks, Luca
