RE: SYSDATE time different from server time
Date: Tue, 2 Jun 2015 17:25:16 -0400
Message-ID: <82D67D213EB2744C8CBF9BE50C615F65018C8674_at_NSTMC708PEX.ubsamericas.net>
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_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Dennis Williams
Sent: Tuesday, June 02, 2015 4:59 PM
To: oracle-l_at_freelists.org
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.
-- http://www.freelists.org/webpage/oracle-lReceived on Tue Jun 02 2015 - 23:25:16 CEST