My Oracle Support Banner

SQLException: The server time zone value is unrecognized or represents more than one time zone. (Doc ID 2429876.1)

Last updated on JULY 08, 2019

Applies to:

MySQL Connectors - Version 5.1 and later
Information in this document applies to any platform.
Error:
SQLException: The server time zone value 'PDT' is unrecognized or represents more than one time zone.

Goal

Information about timezone issues and daylight savings time that throw errors similar to below:

SQLException: The server time zone value 'PDT' is unrecognized or represents more than one time zone.
java.sql.SQLException: The server time zone value 'CEST' is unrecognized or represents more than one time zone.

 

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Goal
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.