Aw: Re: Re: Given geographic coordinates, how does oracle determine the correct timezone?
From: <rogel_at_web.de>
Date: Thu, 15 Mar 2018 14:22:44 +0100
Message-ID: <trinity-ab6855fe-c13d-4b80-96c7-bdbacecf8e35-1521120164215_at_3c-app-webde-bs40>
--
--
http://www.freelists.org/webpage/oracle-l
Received on Thu Mar 15 2018 - 14:22:44 CET
Date: Thu, 15 Mar 2018 14:22:44 +0100
Message-ID: <trinity-ab6855fe-c13d-4b80-96c7-bdbacecf8e35-1521120164215_at_3c-app-webde-bs40>
just to hijack Gus' thread a bit more and to complement Norman's remarks here the link to the docs
https://docs.oracle.com/en/database/oracle/oracle-database/18/nlspg/datetime-data-types-and-time-zone-support.html#GUID-D8C7A7EB-A507-42A2-9B10-5301E822A7F2
Gesendet: Donnerstag, 15. März 2018 um 12:51 Uhr
Von: "Stefan Knecht" <knecht.stefan_at_gmail.com>
An: "Norman Dunbar" <oracle_at_dunbar-it.co.uk>
Cc: oracle-l <oracle-l_at_freelists.org>
Betreff: Re: Re: Given geographic coordinates, how does oracle determine the correct timezone?
Von: "Stefan Knecht" <knecht.stefan_at_gmail.com>
An: "Norman Dunbar" <oracle_at_dunbar-it.co.uk>
Cc: oracle-l <oracle-l_at_freelists.org>
Betreff: Re: Re: Given geographic coordinates, how does oracle determine the correct timezone?
Thanks Normal
Interesting that in most places I've seen it was used like this:
E.g. with UTC or another abbreviation. So yeah, some work, some don't. So I suppose using the names is the better approach if using it programmatically.
But let's not hijack Gus' thread here :)
On Thu, Mar 15, 2018 at 6:32 PM, Norman Dunbar <oracle_at_dunbar-it.co.uk> wrote:
According to the docs, for 12c, section 5.8 in the SQL Language Ref, you must use time zine names, in single quotes, not time zone abbreviations.
I have found that some abbreviations work, but not all. The docs mention that if you need daylight savings etc, then the names must be used. The working abbreviations won't give correct results.
HTH
Cheers,
Norm.
--
Sent from my Android device with K-9 Mail. Please excuse my brevity.
//
zztat - The Next-Gen Oracle Performance Monitoring and Reaction Framework!
Visit us at zztat.net | Support our Indiegogo campaign at igg.me/at/zztat | _at_zztat_oracle