Page 1 of 1

Setting Session TimeZone When Using NET Option

Posted: Tue 18 Apr 2006 18:52
by wvpa
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.

Posted: Thu 20 Apr 2006 09:45
by Challenger
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'