RE: SYSDATE time different from server time

From: <>
Date: Tue, 2 Jun 2015 17:25:16 -0400
Message-ID: <>


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: [] On Behalf Of Dennis Williams Sent: Tuesday, June 02, 2015 4:59 PM
Subject: SYSDATE time different from server time  


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  

Thank you,

Dennis Williams

Please visit our website at 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.

Received on Tue Jun 02 2015 - 23:25:16 CEST

Original text of this message