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.
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,
on the original table, I get the below from the CONNECT table.
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
This might make sense because the original value exceeds the limit for TIMESTAMP on MariaDB.