Re: Daylight savings and timezones

No, by setting the TZ of the server to GMT, Oracle will always return times in GMT. Oracle just makes a call to the OS for the current time.

By the way, you can reverse engineer the time zone for all but the two hours in the fall. I have gone through all of this with my company.

--
Robert Fazio, Oracle DBA
rfazio_at_home.com
remove nospam from reply address
http://24.8.218.197/
"Jeffrey C. Dege" <jdege_at_jdege.visi.com> wrote in message
news:slrn8hchc7.iop.jdege_at_jdege.visi.com...


> On Mon, 08 May 2000 03:16:17 GMT, Bob Fazio <rfazio_at_home.com.nospam>

 wrote:


> >I thing the suggestion was to set the timezone to GMT.

>

> I can't set the timezone to GMT if I don't know what the timezone of the

> server is.  The Oracle built-in function that does timezone conversion

> requires both the from and to timezones to be specified.  There isn't

> a simple local-to-gmt conversion.

>

> All of this seems excessively complicated for a problem that would be

> inherent in any 24x7 operation.  I'd have expected there to be a common

> approach.

>

> --

> It must be remembered that there is nothing more difficult to plan, more

> doubtful of success, nor more dangerous to manage, than the creation of

> a new system.  For the initiator has the emnity of all who would profit

> by the preservation of the old institutions and merely lukewarm defenders

> in those who would gain by the new ones.

>                 -- Niccolo Machiavelli, 1513