Skip site navigation (1) Skip section navigation (2)

Re: Time bug with small years

From: Richard Huxton <dev(at)archonet(dot)com>
To: Rod Taylor <pg(at)rbt(dot)ca>
Cc: pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Time bug with small years
Date: 2011-11-24 12:58:27
Message-ID: 4ECE3F73.7000207@archonet.com (view raw or flat)
Thread:
Lists: pgsql-hackers
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

In response to

pgsql-hackers by date

Next:From: Heikki LinnakangasDate: 2011-11-24 13:07:51
Subject: Re: pg_upgrade relation OID mismatches
Previous:From: Alexander ShulginDate: 2011-11-24 12:33:41
Subject: Re: Notes on implementing URI syntax for libpq

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group