You need to add a serverTimezone
property to the connection properties for that MySQL connection - eg:
serverTimezone=UTC
or serverTimezone=America/Los Angeles
. There's a change going into 7.9.11 that will automatically add the gateway's timezone to your connection string if it's not already populated, but until that happens you will need to set it manually.
1 Like