Details

      Description

      I am trying to make a CONNECT table to a table on an IBM database.
      I failed to read TIMESTAMP columns.

      Below is the official manual describing netezza TIMESTAMP, it is a replacement for DATETIME in the other database.

      http://www-01.ibm.com/support/knowledgecenter/SSBJG3_2.5.0/com.ibm.gen_busug.doc/c_fgl_odiagntz_005.htm

      Since TIMESTAMP in MariaDB can hold only limited values,

      '1970-01-01 00:00:01' (UTC) to '2038-01-09 03:14:07' (UTC)

      I made a CONNECT table defining the column definition as DATETIME which supports values,

      '1000-01-01 00:00:00.000000' to '9999-12-31 23:59:59.999999'

      The problem I am getting is that when there is the value,

      '9999-12-31 23:59:59'

      on the original table, I get the below from the CONNECT table.

      '1970-01-01 09:00:00'

      The time difference from UTC in Japan is just 9 hours.
      Does this mean there is some conversion done when a TIMESTAMP (original table) value is converted to a DATETIME (CONNECT) value?

      When I created the CONNECT table making the column definition TIMESTAMP, it returned the below

      '0000-00-00 00:00:00'

      This might make sense because the original value exceeds the limit for TIMESTAMP on MariaDB.

        Attachments

          Activity

            People

            • Assignee:
              bertrandop Olivier Bertrand
              Reporter:
              takuya Takuya Aoki
            • Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: