Oracle Timezone question

Platform: Oracle 9.2 on Solaris 8.

We have a packaged app that running in two U.S. locations, both in the Central time zone. The db is located in Mountain time zone. The only date/time datatype in the application's schema is DATE. It is also rumored that a lot of the application date/time data is actually stored in VARCHAR2 or NUMBER columns. Users are complaining about having to mentally adjust when dealing with times. Managent (as always!) is looking for a magic parm I can set to make the problem go away.

I've read all of the relevant docs on tahiti, as well as several promising threads from the ng archives. Quite frankly, I'm having trouble getting my head around it all, but it appears that there is no way out short of going into the app itself. Resetting the time or timezone in Solaris itself is not an option.

Can anyone give me a reasonably concise description of what our options are? Meanwhile, I'm continuing to re-re-read all the hits I get from searching tahiti for 'timezone'.

Thanks. Received on Wed Jan 28 2004 - 09:48:22 CST