ibm midrange - Is QTIMZON used to convert dates/timestamps on DB2 for i? -
In this regard, in the timestone column, UTC 0000 is converted, the system setting from the timezone specified in QtmZone? For example, if QTIMZON is set to UTC-400, then there is a conversion in UTC 0000 before inserting the row?
I ask because and changes from UTC to / operating-system-specified time-zone.
I am aware of a special register that believes in me that no conversion is done automatically, but I have to make sure that.
For DB / 2, I do not convert any time zone according to the following tests: Select data from
CHGSYSVAL SYSVAL (QTIMZON) VALUE (QN0500EST3)
< Create the code> table qtemp / test form (select now) SYSISBM / SYSDUMMY1 TS .... + .... 1 .... + .... 2 .... +. TS 2014-04-21-17.52.17.813498 CHGSYSVAL SYSVAL (QTIMZON) VALUE (Q0000UTC)
Choose from QTEMP / test TS .... .... .... .... .... .... 2 ..... Ts 2014-04-21-17.52.17.813498
Comments
Post a Comment