connect to PGSQL 10.6. but error with Timezone class about p3 HOT 5 CLOSED

Hmm, ROK seems to be a deprecated abbreviation for Asia/Seoul. ZTimezone does understand all modern timezone designations (the long ones in /etc/share/zonetab) but only a few abbreviations.

Could you declare/configure your database to use Asia/Seoul as timezone ?

The problem is that P3Client tries to automatically adapt to the timezone used by the database.

You can have a look at P3ClientTest>>#testTimezone where there are some experiments with changing the connection's time zone.

Maybe I should extend https://github.com/svenvc/ztimestamp to undestand all abbreviations that occur in /etc/share/zonetab - I have to think about that.

from p3.

1. I did not use "ROK" intentionally. Of course, we made the basic settings in linux environment with "Asia/Seoul".
2. At the linux console, we confirmed that the zone command differs from the zoneinfo file of "ROK" and "Asia/Seoul".
3. I do not know how to switch separately because I did not use "ROK" deliberately at this point.

I guess. Even if I set it to "Asia/Seoul" on linux system, "ROK" is returned. Is there a way to tell if this is a problem with ZTimestamp or a feature of the linux system?

from p3.

Hi,

I extended ZTimestamp's ZTimezone to support less common IDs like ROK (in addition to the modern Asia/Seoul variant). Could you try by loading the latest master version from https://github.com/svenvc/ztimestamp please ?

BTW, this might be helpful too https://phili.pe/posts/timestamps-and-time-zones-in-postgresql/

It might also be useful to give P3Client an option to better manage P3Client>>#initializeConverter and P3Converter>>#initializeFrom: when unknown values are encountered. I will look into that too.

Sven

from p3.

I will close this issue soon as fixed, as it should work from my POV.

from p3.

svenvc/ztimestamp@1a139e5

See #testROK

from p3.