Devart Forums

Hi,

How do I change the timezone of Postgres session?

Thanks

Roberto Chostakovis

You should execute the following SQL command:

Hi,

I tried this using TUniSql but it doesn´t work.

UniDAC appears to use the computer´s time zone and not allow to change this.

Running the scripts (select and timezone change) manually works fine.

Regards

Roberto Chostakovis

UniDAC always uses the computer time zone for TIMESTAMP WITH TIMEZONE fields. UniDAC does not use PostgreSQL client, and UniDAC does not contain the time conversion rules for all time zones. UniDAC uses time conversion rules from Windows settings.

How do I change this?

I am using UniDAC in a webserver application that runs under GMT+0.

I have users from many timezones using it and I have to convert the timestamp for their location.

I have to be able at least to sum or subtract # hours from timestamp. How I do that?

Regards

Roberto Chostakovis

Could you please tell me where the conversion take place in source code?

My subscription include source code and I can try to create a workaround.

Regards

Roberto Chostakovis

See the UTCTimeToLocalTime function in the PgObjects unit.

Thank you! I got how it works and create a workaround.

I´ve changed the PgObjectsUni.pas in the following ways:

1 - Change the TimeZoneInformation variable to UniDACPgTimeZoneInfomation and moved it to Interface section, making it Global.

2 - Changed the functions that use this variable.

3 - The UniDACPgTimeZoneInformation is initialized as it was, with no change.

On my projet, I include PgObjectsUni at uses clausule and at runtime changed the bias value to reflect the timezone that I want.

I think that is a very simple way to give flexibility to UniDAC to handle with timezones.

Would you like that I send the PgObjectsUni.pas to you?

Regards

Roberto Chostakovis

We have made such changes ourselves:

We have renamed TimeZoneInformation to PgTimeZoneInformation and placed it to the interface section. This fix will be included in the next UniDAC build.