Date time offset while connecting to PostgreSQL Server

[learningtoqlik]

We recently migrated our QlikSense enterprise server from on-prem to azure VM.

Since the migration, after day light savings implimentation, one of our data connection that connects to an Amazon Aurora database using an ODBC PostgreSQL unicode connector is returning all tables containing date and time values with the offset of one hour. I have tried comparing all the system and connection settings to the on prem setup and haven't found any setting that is different or can override this. 

Any suggestions.

[DataKnight1]

Potentially sounds like a setting Azure side - can this be amended in script?

[learningtoqlik · Accepted solution]

I was able to fix this issue by enforcing timezone within the connector like this. 

[Rahul18]

Check VMs timezone and DST setting
Force the Timezone at ODBC level (Advanced Settings)
Check if timestamps are timestamp with time zone or timestamp without time zone
Override in Qlik Load Script (if needed)