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:

https://docs.oracle.com/database/121/SQLRF/functions208.htm#SQLRF06125

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

--
http://www.freelists.org/webpage/oracle-l