Change timezone

Ignition
1

Hello.

We have two Gateways of Ignition, one with Ignition Edge with timezone Europe/Spain and other Ignition complete with designer in timezone UTC. We execute a script on gatweway and transaction groups on gateway with timezone UTC, we need used the datas on timezone Europe/Spain, then we have changed the query to look on database, but this change is necessary rewrite when the hour is change in Spain.

Is posible realise this change automactly?

We are waiting for your answer.
Best regards.

2

Use column types in your database that are time zone aware, like timestamptz in PostgreSQL. Ignition will handle the rest.

3

Thank you for your answer, I will check it.