Uploaded image for project: 'MariaDB Connector/ODBC'
  1. MariaDB Connector/ODBC
  2. ODBC-70

SQL_C_TIMESTAMP to DATETIME columns stored '1970-01-01 00:00:00' for value '0000-00-00 00:00:00'

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • 2.0.12
    • 3.0.7, 2.0.19
    • General
    • None
    • Windows 64-bit, Linux 64-bit

    Description

      If we bind parameter (to Aurora database via MariaDB ODBC driver) of C type SQL_C_TIMESTAMP to a DATETIME column in the table, we are seeing data loaded is '1970-01-01 00:00:00' for value '0000-00-00 00:00:00' in the SQL_TIMESTAMP_STRUCT.

      Same if we try to insert in a TIMESTAMP column (instead of DATETIME) of the table, then value is stored properly as '0000-00-00 00:00:00'.

      Also, instead of SQL_C_TIMESTAMP, if we bind as SQL_C_CHAR with same value to DATETIME column, then as well value is correctly stored as '0000-00-00 00:00:00'.

      Attachments

        Activity

          Transition Time In Source Status Execution Times
          Lawrin Novitsky made transition -
          Open In Progress
          		681d 21h 35m 1
          Lawrin Novitsky made transition -
          In Progress Closed
          		3h 53m 1

          People

            Lawrin Lawrin Novitsky
            rdhuvad Rahul Dhuvad
            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.