Hi,
I have a task to migrate H2 db into Postgres DB and found some not constant
behavior of timestamp fields when data is read. There are 2 columns, one
with summer time (DST on) and on with winter time (DST off). This is how
those are rendered when system's time zone is set to UTC: 2022-07-14
thanks for a quick response!
My task is a data migration and I'm working with TIMESTAMP (without time
zone) field as this H2 DB was created in another system and I cannot affect
this anyhow.
So, as you've said, the Timestamp field should represent local date,
without time zone info, so it is ex
This sounds very likely as a reason! I'm using H2 v.1.4.192. How do I check
if it uses PageStore backend? Also, is there any documentation which
specifies this problem, if you know? Thanks in advance
On Tuesday, March 14, 2023 at 11:43:18 PM UTC+9 Evgenij Ryazanov wrote:
> > Unfortunately, I sh
ing else
On Tuesday, March 14, 2023 at 11:48:26 PM UTC+9 Nazar Viliura wrote:
> This sounds very likely as a reason! I'm using H2 v.1.4.192. How do I
> check if it uses PageStore backend? Also, is there any documentation which
> specifies this problem, if you know? Thanks in advan
This is *.h2.db file(
So, the issue is solved: PageStore backend cannot read persisted timestamps
back properly if there is any difference between DST transition rules.
Thank you very much for this and quick responses
On Tuesday, March 14, 2023 at 5:18:30 PM UTC+2 Evgenij Ryazanov wrote:
> Tak