Setting Session TimeZone When Using NET Option

wvpa · Post by **wvpa** » Tue 18 Apr 2006 18:52

We use the NET options for our TOraSession objects. However, we've recently noticed that the session timezone indicates GMT rather than sending the local system offset or region information. Any help on determining how to send the local system timezone would be appreciated.

Challenger · Post by **Challenger** » Thu 20 Apr 2006 09:45

With NET option ODAC doesn't support setting of timezone and other NLS parameters from local system.
You should set timezone manually with statement like this:

ALTER SESSION SET TIME_ZONE = '+03:00'