Re: Re: Given geographic coordinates, how does oracle determine the correct timezone?

From: Stefan Knecht <>
Date: Thu, 15 Mar 2018 18:51:33 +0700
Message-ID: <>

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 <> 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.
> 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 | Support our Indiegogo campaign at |

Received on Thu Mar 15 2018 - 12:51:33 CET

Original text of this message