There may be hope with an external C function (man ctime). However you
will have to create a GMTDATE function (no way to redefine SYSDATE -
wouldn't be advisable anyway) and I have a very limited faith in
external functions performance-wise.
Marc Perkowitz wrote:
>
> 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: Stephane Faroult
INET: sfaroult_at_oriole.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:58:40 CST
