topic Time zone for Qlik Replicate Change Tables in Qlik Replicate

Time zone for Qlik Replicate Change Tables

zacker20 — Mon, 30 Jan 2023 14:33:54 GMT

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?

Re: Time zone for Qlik Replicate Change Tables

Steve_Nguyen — Mon, 30 Jan 2023 14:41:04 GMT

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-info/ta-p/1850739

https://help.qlik.com/en-US/replicate/November2022/Content/Global_Common/Content/SharedEMReplicate/Customize%20Tasks/tasks_headColumns.htm

Re: Time zone for Qlik Replicate Change Tables

zacker20 — Mon, 30 Jan 2023 14:53:49 GMT

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

Re: Time zone for Qlik Replicate Change Tables

Steve_Nguyen — Mon, 30 Jan 2023 14:59:51 GMT

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-info/ta-p/1850739

Re: Time zone for Qlik Replicate Change Tables

Heinvandenheuvel — Mon, 30 Jan 2023 15:01:12 GMT

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.