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

Popular posts from this blog

Verilog Error: output or inout port "Q" must be connected to a structural net expression -

jasper reports - How to center align barcode using jasperreports and barcode4j -

c# - ASP.NET MVC - Attaching an entity of type 'MODELNAME' failed because another entity of the same type already has the same primary key value -