Uploaded image for project: 'MariaDB Connector/J'
  1. MariaDB Connector/J
  2. CONJ-647

SYSTEM Time zone not working correctly for client connection

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • None
    • N/A
    • datetime
    • 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:

      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.

      Attachments

        Activity

          diego dupin Diego Dupin added a comment -

          Closing since datetime behavior is corrected with 3.x.

          diego dupin Diego Dupin added a comment - Closing since datetime behavior is corrected with 3.x.

          People

            diego dupin Diego Dupin
            JZingg Jerome Zingg
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.