topic Re: Date time offset while connecting to PostgreSQL Server in Connectivity & Data Prep

Date time offset while connecting to PostgreSQL Server

learningtoqlik — Tue, 17 Jun 2025 12:44:16 GMT

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.

Re: Date time offset while connecting to PostgreSQL Server

DataKnight1 — Thu, 26 Jun 2025 14:09:40 GMT

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

Re: Date time offset while connecting to PostgreSQL Server

learningtoqlik — Fri, 27 Jun 2025 07:21:46 GMT

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

Re: Date time offset while connecting to PostgreSQL Server

Rahul18 — Sat, 28 Jun 2025 16:05:01 GMT

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)