thin mode: detect timezone

[BayerSe]

The thin and the thick mode drivers behave differently with respect to timezones: thin uses UTC, whereas thick detects the local timezone. This is confusing for people migrating from cx_Oracle to the new thin driver, see e.g. #140.

It would be great if the thin mode driver would detect the local time zone, too, so that the following script always returns the same value, independent of the thick flag.

import oracledb

user ="..."
password = "..."
dsn = "..."

thick = False

if thick:
    oracledb.init_oracle_client()

with oracledb.connect(user=user, password=password, dsn=dsn) as connection:
    with connection.cursor() as cursor:
        tz = cursor.execute("SELECT SESSIONTIMEZONE FROM DUAL").fetchone()[0]

print(f"Timezone: {tz}")

[anthony-tuininga]

This is on our (long) list of things to do. I'll let @cjbj comment on priority!

[anthony-tuininga]

Ok. I had a chance to address this. I have pushed a patch that should correct this issue. If you are able to build from source you can verify that it corrects your issue as well.

[anthony-tuininga]

This has been included in version 1.3.0 which was just released.

[BayerSe]

Hi @anthony-tuininga; sorry for replying only now. I've tested it, and it works perfectly. Many thanks!