|
When connecting to a MariaDB database which was the defaults of @@global.time_zone = SYSTEM and @@session.time_zone = SYSTEM, the driver is reflecting my US/Eastern timezone as +20 from UTC, rather than -4 from UTC (i.e., in the wrong direction).
The problem is queries such as: select cast('2018-08-01' as date)
, return 2018-07-31 (-20 hours from 2018-08-01 00:00:00.000) rather than the correct 2018-08-01.
Connecting to the same database using the MySQL Connector/j driver does not exhibit this incorrect behavior.
|