Dennis
Did you do a quick search in the list archibe..
There have been some email exchanges in the past on this topic
See if below helps
References: How To setup TNS listener to Show More Than one Timezone (Doc ID
399448.1)
Reference: How to set different timezone when starting up cluster DB? (Doc ID
351534.1)
- Raj Pande
UBS AG
CORE ENG PLATFORM AS A SERVICE (PAAS)
1000 Lincoln Harbor, floor 10, Weehawken NJ 07086
Work:+1 201 352 0441 (internal: 19 422 0441)
Out of Office: Jun 13 – Jun 20, 2015
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On
Behalf Of Dennis Williams
Sent: Tuesday, June 02, 2015 4:59 PM
To: oracle-l@xxxxxxxxxxxxx
Subject: SYSDATE time different from server time
List,
We are trying to migrate a database from a standalone server to a server that
hosts many databases. The problem is that the server time is different from the
time currently used (different time zone). The application calls SYSDATE. The
application can't be modified and there are many years of data with the current
time setting.
Is there a way to have SYSDATE return a time different from the server? Like a
few hours ahead or behind?
Oracle version 11.2.0.4
Thank you,
Dennis Williams
Please visit our website at
http://financialservicesinc.ubs.com/wealth/E-maildisclaimer.html
for important disclosures and information about our e-mail
policies. For your protection, please do not transmit orders
or instructions by e-mail or include account numbers, Social
Security numbers, credit card numbers, passwords, or other
personal information.
