Re: timezones BCE - Mailing list pgsql-hackers

From chap@anastigmatix.net
Subject Re: timezones BCE
Date
Msg-id b74401fc17146409effbff4e5e0a64d8@anastigmatix.net
Whole thread Raw
In response to Re: timezones BCE  (Dave Cramer <davecramer@gmail.com>)
List pgsql-hackers
On 2022-04-13 14:13, Dave Cramer wrote:
> 
> Oh please don't do something bespoke. I'm trying to make this work with 
> the
> JDBC driver.
> So it has to be at least compatible with other libraries.

Looks like Java agrees with the offset, prior to Toronto's 1895 adoption
of the hour-wide zone:

jshell> java.time.ZoneId.of("America/Toronto").
    ...> getRules().
    ...> nextTransition(java.time.Instant.parse("0101-01-01T00:00:00Z"))
$1 ==> Transition[Gap at 1895-01-01T00:00-05:17:32 to -05:00]

Regards,
-Chap



pgsql-hackers by date:

Previous
From: Michael Paquier
Date:
Subject: Re: CLUSTER on partitioned index
Next
From: Michael Paquier
Date:
Subject: Re: Fixes for compression options of pg_receivewal and refactoring of backup_compression.{c,h}