RE: SYSDATE time different from server time

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-l