Re: Toad timezone error

Posted by Roshan on Feb 19, 2019; 1:52pm
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/Toad-timezone-error-tp2906p7252.html

Yes.

One thing I find weird is that whenever I query a table which is on DB 12.2.0 with client 11g, I am not getting 'timezone' error.

But when I connect to a DB 12.1.0.2 with client 11g and query same table on that database, I am getting 'timezone' error.

I noticed that timezone was not set on DB 12.1.0.2
SQL>  SELECT DBTIMEZONE, SESSIONTIMEZONE from dual;

DBTIME
------
SESSIONTIMEZONE
---------------------------------------------------------------------------
+00:00
+00:00

Please advise.

Regards,

Roshan