From oracle-l-bounce@freelists.org Thu Oct 20 10:05:39 2005 Return-Path: Received: from air891.startdedicated.com (root@localhost) by orafaq.com (8.12.10/8.12.10) with ESMTP id j9KF5Xu2031612 for ; Thu, 20 Oct 2005 10:05:34 -0500 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air891.startdedicated.com (8.12.10/8.12.10) with ESMTP id j9KF4lvX031320 for ; Thu, 20 Oct 2005 10:04:52 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id A4718209B03; Thu, 20 Oct 2005 10:04:30 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 10199-01; Thu, 20 Oct 2005 10:04:30 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 14C00209A6A; Thu, 20 Oct 2005 10:04:30 -0500 (EST) X-MimeOLE: Produced By Microsoft Exchange V6.0.6603.0 content-class: urn:content-classes:message MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01C5D587.47F47098" Subject: GMT timezone - login trigger Date: Thu, 20 Oct 2005 11:02:25 -0400 Message-ID: <5042FDC675779848A113F70D54F587490790743B@KAMRICEXCLUS.us.kline.com> X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: GMT timezone - login trigger Thread-Index: AcXVh0gF+/Oddx6cSA2G2lVsutdHMw== From: "Fedock, John (KAM.RHQ)" To: "Oracle-L (E-mail)" X-OriginalArrivalTime: 20 Oct 2005 15:02:26.0181 (UTC) FILETIME=[48650B50:01C5D587] X-archive-position: 27248 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: John.Fedock@us.kline.com Precedence: normal Reply-To: John.Fedock@us.kline.com X-list: oracle-l X-Virus-Scanned: by amavisd-new-20030616-p9 (Debian) at avenirtech.net X-mailscan-MailScanner-Information: Please contact the ISP for more information X-mailscan-MailScanner: Found to be clean X-MailScanner-From: oracle-l-bounce@freelists.org X-Spam-Checker-Version: SpamAssassin 2.63 (2004-01-11) on air891.startdedicated.com X-Spam-Level: X-Spam-Status: No, hits=-2.4 required=5.0 tests=AWL,BAYES_00, HTML_FONTCOLOR_RED,HTML_MESSAGE autolearn=no version=2.63 ------_=_NextPart_001_01C5D587.47F47098 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Looking for some advice regarding timezones. On my HP-UX servers, I = have serveral databases running (v8-v10). I want one of those databases = to run at GMT time - for storing sysdate, etc, =20 The TZ=3DEST5EDT at the server level. =20 The database is already setup for GMT time, verified by the following: select dbtimezone from dual=20 DBTIMEZONE=20 ----------=20 GMT=20 According to the notes on Metalink, the above only applies to columns = defined as "timestamp with timezone".=20 A check of the date shows the server time being used (select sydate from = dual).=20 It looks like my only option is a login trigger does an "alter session = set time_zone=3Ddbtimezone;" =20 Any other ideas? The database in question for this is a 9.2.x Thanks. John Fedock K Line America, Inc. john.fedock@ us.kline.com ------_=_NextPart_001_01C5D587.47F47098 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable GMT timezone - login trigger

Looking for some advice regarding = timezones.  On my HP-UX servers, I have serveral databases running = (v8-v10).  I want one of those databases to run at GMT time - for = storing sysdate, etc, 

The TZ=3DEST5EDT at the server = level. 
The database is already setup for GMT = time, verified by the following:
select dbtimezone from dual
DBTIMEZONE
----------
GMT
According to the notes on Metalink, = the above only applies to columns defined as "timestamp with = timezone".
A check of the date shows the server = time being used (select sydate from dual).
It looks like my only option is a = login trigger does an "alter session set = time_zone=3Ddbtimezone;"  
Any other ideas?   The = database in question for this is a 9.2.x
Thanks.

John Fedock
K Line America, Inc.
john.fedock@ us.kline.com

------_=_NextPart_001_01C5D587.47F47098-- -- http://www.freelists.org/webpage/oracle-l