MySQL Forums
Forum List  »  Connector/J, JDBC and Java

Advanced Search
New Topic

Re: java.sql.SQLException: The server time zone value 'EDT'
Posted by: Filipe Silva
Date: August 09, 2019 09:15AM

You should set your server time zone to something more specific than the generic timezone EDT, which, probably, MySQL server is borrowing from the operating system, btw.

Please get more details from https://dev.mysql.com/doc/refman/8.0/en/time-zone-support.html#time-zone-variables.

If for some reason you are unable to change the server time zone settings, you can still set it on the client using the connection string option serverTimezone with, for example: 
serverTimezone=America/New_York

IHTH

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Written By
Posted
java.sql.SQLException: The server time zone value 'EDT'
Mariia Kotenko
August 07, 2019 08:14PM
Re: java.sql.SQLException: The server time zone value 'EDT'
Filipe Silva
August 09, 2019 09:15AM
Re: java.sql.SQLException: The server time zone value 'EDT'
Zhenlei Huang
October 29, 2019 05:03AM
Re: java.sql.SQLException: The server time zone value 'EDT'
Filipe Silva
October 31, 2019 09:37AM


Sorry, you can't reply to this topic. It has been closed.

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.