Re: DB2 Timestamps with time zone information

On 04-Aug-2016 13:49 -0500, Matt Olson wrote:

So apparently I may have found another DB2 deficiency with the IBM
i's flavor of DB2 that is causing no end of pain and suffering.

Does anyone know if 7.3 perhaps supports this SQL:

CREATE TABLE tz(tstz TIMESTAMP WITH TIME ZONE);

Right now on 7.1 it doesn't seem to work.

Works just fine on DB2 LUW versions of DB2.

Huh. Odd then, that they do not actually mention support for that data-type\syntax in the DB2 LUW docs. That data-type\syntax does however, show as supported in the DB2 for z docs.

DB2 for Linux UNIX and Windows 11.1.0-> Database fundamentals->SQL
Statements->CREATE TABLE
[http://www.ibm.com/support/knowledgecenter/en/SSEPGG_11.1.0/com.ibm.db2.luw.sql.ref.doc/doc/r0000927.html]
"…
TIMESTAMP(integer) or TIMESTAMP
For a timestamp. The integer must be between 0 and 12 and specifies the precision of fractional seconds from 0 (seconds) to 12 (picoseconds). The default is 6 (microseconds).
…"

DB2 for z/OS 11.0.0->DB2 SQL->Statements->CREATE TABLE
[https://www.ibm.com/support/knowledgecenter/en/SSEPEK_11.0.0/sqlref/src/tpc/db2z_sql_createtable.html]
"…
TIMESTAMP(integer) WITHOUT TIME ZONE
For a timestamp. integer specifies the optional timestamp precision attribute and must be in the range from 0 to 12. The timestamp precision denotes the number of fractional second digits that are included in the timestamp. The default is 6.
TIMESTAMP(integer) WITH TIME ZONE
For a timestamp with time zone. integer specifies the optional timestamp precision attribute and must be in the range from 0 to 12. The timestamp precision denotes the number of fractional second digits that are included in the timestamp. The default is 6.
…"