Time zone for Qlik Replicate Change Tables

[zacker20]

The header_timestamp column on the Qlik Replicate Change Tables that are created when using the Store Changes setting is in a different timezone then what my server is in.  The server is set to Eastern and on the Qlik Replicate console, timestamps are in eastern for logs and so forth.  However, when data is stored in the change table on SQL Server, it is using a time zone that is 6 hours ahead of me.  How do I get that to be in the time zone of the server? Is there another setting to change? 

[Steve_Nguyen]

we have many article on this subject:

https://community.qlik.com/t5/Qlik-Replicate/Replicate-header-timestamp-Clarification/td-p/1923015

https://community.qlik.com/t5/Official-Support-Articles/How-to-get-the-Replication-change-timestamp-...

https://help.qlik.com/en-US/replicate/November2022/Content/Global_Common/Content/SharedEMReplicate/C...

[zacker20]

I don't see where those articles say I can change the UTC timezone of the actual Change Table that Qlik generates? 

[Steve_Nguyen · Accepted solution]

you can not change the change table, however ,

Alternatively, you can get this info by adding to the target table a new column and with a transformation rule populate it with the value of the required header timestamp.  To define the column with the transformation rule go to:

• Table settings -> transform --> add column
• On the added column, choose expression builder (fx) --> headers tab and choose the required header column

https://community.qlik.com/t5/Official-Support-Articles/How-to-get-the-Replication-change-timestamp-...

[Heinvandenheuvel]

You cannot change the UTC timezone  for the Change Table Timestamp.

This is by design in anticipation of multiple tasks from multiple timezones contributing to a single CT table, or multiple CT tables in the same target DB

You'll have to create a View or add a 'computed-by' column to the change table if you feel you need 'local' time.

Hein.