Re: Re: Given geographic coordinates, how does oracle determine the correct timezone?
From: Norman Dunbar <oracle_at_dunbar-it.co.uk>
Date: Thu, 15 Mar 2018 11:56:35 +0000
Message-ID: <15E3D60F-D4FD-4C8C-BC54-C9E5ADB537A8_at_dunbar-it.co.uk>
Date: Thu, 15 Mar 2018 11:56:35 +0000
Message-ID: <15E3D60F-D4FD-4C8C-BC54-C9E5ADB537A8_at_dunbar-it.co.uk>
Just tried getting systimestamp at time zone 'EST' and also at 'America/Detroit' - there was indeed a difference even though Detroit is in EST.
EST is 06:54:58 -05:00 where Detroit is 07:54:58 -04:00.
Cheers,
Norm.
--
Sent from my Android device with K-9 Mail. Please excuse my brevity.
--
http://www.freelists.org/webpage/oracle-l
Received on Thu Mar 15 2018 - 12:56:35 CET