Robert Haas writes:
> On Wed, Nov 23, 2011 at 11:45 PM, Rod Taylor wrote:
>> sk_test=# select '1894-01-01'::timestamp with time zone;
>> timestamptz
>> --
>> 1894-01-01 00:00:00-05:17:32
>> (1 row)
> On my system, all current time zone offsets are multiples
On Wed, Nov 23, 2011 at 11:45 PM, Rod Taylor wrote:
> sk_test=# select '1894-01-01'::timestamp with time zone;
> timestamptz
> --
> 1894-01-01 00:00:00-05:17:32
> (1 row)
I believe that -05:17:32 is the offset of your local time zone as
compared with UTC. Fo
On 24/11/11 04:45, Rod Taylor wrote:
I have no idea what is going on with the minutes/seconds, particularly for
years under 1895 where it gets appended onto the timezone component?
sk_test=# select version();
version
-
I have no idea what is going on with the minutes/seconds, particularly for
years under 1895 where it gets appended onto the timezone component?
sk_test=# select version();
version
Po