On Wed, Nov 23, 2011 at 11:45 PM, Rod Taylor <p...@rbt.ca> 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. For example: rhaas=# select now(); now ------------------------------ 2011-11-24 13:46:46.68016+00 (1 row) rhaas=# set time zone 'Australia/Eucla'; SET rhaas=# select now(); now ---------------------------------- 2011-11-24 22:31:55.792565+08:45 (1 row) rhaas=# set time zone 'UTC'; SET rhaas=# select now(); now ------------------------------- 2011-11-24 13:46:58.480484+00 (1 row) On my system, all current time zone offsets are multiples of 15 minutes, but historically that wasn't the case. It seems that in your local time zone, the offset versus UTC was, as of January 1, 1894, minus five hours, seventeen minutes, and 32 seconds. -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers