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>
On Wed, 13 Apr 2022 at 14:10, Tom Lane wrote:
> c...@anastigmatix.net writes:
> > On 2022-04-13 12:33, Dave Cramer wrote:
> >> Specifically why the -05:17:32
>
> > Timezones were regularized into their (typically hour-wide) chunks
> > during a period around the late nineteenth century IIRC.
>
> >
c...@anastigmatix.net writes:
> On 2022-04-13 12:33, Dave Cramer wrote:
>> Specifically why the -05:17:32
> Timezones were regularized into their (typically hour-wide) chunks
> during a period around the late nineteenth century IIRC.
> If you decompile the zoneinfo database to look at America/Tor
On 2022-04-13 12:33, Dave Cramer wrote:
test=# set timezone to 'America/Toronto';
SET
test=# select '0101-01-01'::timestamptz;
timestamptz
--
0101-01-01 00:00:00-05:17:32
Specifically why the -05:17:32
Timezones were regularized into their (typically hour-
Can someone help me understand
select '0101-01-01'::timestamptz;
timestamptz
0101-01-01 00:00:00+00
(1 row)
test=# set timezone to 'America/Toronto';
SET
test=# select '0101-01-01'::timestamptz;
timestamptz
--
0101-01-01 00:00:
