SYSDATE time different from server time

  • From: Dennis Williams <oracledba.williams@xxxxxxxxx>
  • To: "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
  • Date: Tue, 2 Jun 2015 15:58:34 -0500

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

Other related posts: