Re: Error when setting useTimezone=true

[Paul Darling]

Ok thanks.

FWIW. My problem is resolved by setting the time zone in the JDBC URL using "serverTimezone=...", and setting the same time zone as the per session time zone for the created connection. Doesn't matter what the time zone is, as long as the same time zone is specified in the URL and session.

I believe that if 'useTimezone=true' without "serverTimezone=..." meant that the client used MySQL global time zone then setting a per session time zone would not be necessary.

Thanks again for your help,
Paul