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 ---------------------------------------------------------------------------------------------------------------- PostgreSQL 9.1.1 on x86_64-pc-linux-gnu, compiled by gcc-4.6.real (Ubuntu/Linaro 4.6.1-9ubuntu3) 4.6.1, 64-bit (1 row) -- uname -a output: Linux rbt-dell 3.0.0-13-generic #22-Ubuntu SMP Wed Nov 2 13:27:26 UTC 2011 x86_64 x86_64 x86_64 GNU/Linux sk_test=# select '1894-01-01'::timestamp with time zone; timestamptz ------------------------------ 1894-01-01 00:00:00-05:17:32
Floating-point timestamps? Although I thought integer was the default for 9.x - hmm INSTALL says since 8.4
-- Richard Huxton Archonet Ltd -- Sent via pgsql-hackers mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
