From: | Luca Ferrari <fluca1978(at)gmail(dot)com> |
---|---|
To: | pgsql-general <pgsql-general(at)postgresql(dot)org> |
Subject: | UTC-6 or UTC+6? |
Date: | 2019-10-20 09:35:04 |
Message-ID: | CAKoxK+4JuhZiuODdf_103_gEPMa69D1Dhm+qn6PqNmMkTo4nZA@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Andrew Dunstan | 2019-10-20 12:31:38 | Re: jsonb_set() strictness considered harmful to data |
Previous Message | Steve Atkins | 2019-10-20 09:13:04 | Re: jsonb_set() strictness considered harmful to data |