Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
None
-
None
Description
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:
, return 2018-07-31 (-20 hours from 2018-08-01 00:00:00.000) rather than the correct 2018-08-01.select cast('2018-08-01' as date)
Connecting to the same database using the MySQL Connector/j driver does not exhibit this incorrect behavior.
Closing since datetime behavior is corrected with 3.x.