Re: Connector 8 - Datetime Convertion
Posted by: David Garratt
Date: April 16, 2020 01:59AM

I'm working on a related problem and after a little research I found a number of suggestions relating to the jbdc connection string.

jdbc:mysql://localhost:3306/mydatabase?serverTimezone=Europe/London#?connectTimeout=5&socketTimeout=0&autoReconnect=true

In the above example I have added

?serverTimezone=Europe/London#

I'm not sure about the trailing # but I cannot get it to work without it,

See if it helps for you and let me know. Just change my timezone to UTC

Dave

Options: ReplyQuote


Subject
Written By
Posted
Re: Connector 8 - Datetime Convertion
April 16, 2020 01:59AM


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.