Re: minor difference in system_time_zone (5.6)
Posted by: Filipe Silva
Date: May 04, 2020 11:28AM


I believe you are describing a behavior observed after upgrading from Connector/J 5.1 to Connector/J 8.0.

So, to date, Connector/J 8.0 default behavior is the same as Connector/J 5.1 with the option `useLegacyDatetimeCode=false`, and in order to get the same default behavior than Connector/J 5.1, you'll need to set the connection option `serverTimezone=<client_timezone>`, where <client_timezone> is the canonical name of the timezone where the client is running, e.g., Europe/London. Please check this answer from some more details.


Options: ReplyQuote

Written By
Re: minor difference in system_time_zone (5.6)
May 04, 2020 11:28AM

Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.