Oracle-L: Re: setting database time to GMT while server time is local

From: Marc Perkowitz <mperkowitz_at_twjconsulting.com>
Date: Wed, 30 Oct 2002 14:03:44 -0800
Message-ID: <F001.004F7F2B.20021030140344@fatcity.com>

I don't think that's feasible. Unless you're in a non-DST time zone. Otherwise, how could you compensate for the DST switch twice a year?

I guess if you're willing to do manual updates and restart your database twice a year it might work.

Best approach is to set the server to GMT.

Marc Perkowitz
TWJ Consulting, LLP

www.twjconsulting.com

Original Message ----- To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Wednesday, October 30, 2002 2:58 PM

> Is it possible to set database time to GMT while server time is local?
>
> Is this possible on 8.1.7.4 on HP-UX and 9.0.1 on Windows2000?
>
> Any advice is appreciated as I am starting to look into this now.
>
> Thanks.
>
>
> John Fedock
> "K" Line America, Inc.
> www.kline.com
> * john.fedock_at_kline.com
>
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Fedock, John (KAM.RHQ)
> INET: John.Fedock_at_KLINE.com
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Marc Perkowitz
  INET: mperkowitz_at_twjconsulting.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Received on Wed Oct 30 2002 - 16:03:44 CST