Oracle Database Discussions

Hello there,

I am a developer on a governement project where we have approximately 80 databases across the world. Currently, each database is located in the same timezone as the customer; however we are looking into relocating some of the database servers.

We are trying to consolidate the database servers to a central location: One database server having four-seven database instances. The problem is that not all of the database instances will reside in the same timezone. For example, on the Paris database server, we may have four database instances (London, New York, Tokoyo, and Los Angeles).

We have deployed an application that has lots of "sysdate" commands. It is my understanding that the sysdate always retreives the date/timestamp from the Database Server operating system, correct? If this is true, won't all the database instances (London, New York, Tokoyo, and Los Angeles) report the same timestamp from the "sysdate" command?

Is there an easy way (without having to change all the "sysdate" calls in the application) to have the system display the correct time for each database instance using the "sysdate" function?

Thanks in advance for your help.

Thanks,
Mike