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

Re: BUG #2768: dates before year 1600 in timestamptz column give strange results

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Mikko Tiihonen" <mikko(dot)tiihonen(at)iki(dot)fi>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #2768: dates before year 1600 in timestamptz column give strange results
Date: 2006-11-21 01:58:10
Message-ID: 16634.1164074290@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-bugs
"Mikko Tiihonen" <mikko(dot)tiihonen(at)iki(dot)fi> writes:
> PostgreSQL compiled with intdatetime=off
>               stamp               
> ----------------------------------
>  0134-05-06 08:52:26.123459+01:39
>  2134-05-06 09:12:34.123456+02
> (2 rows)

[ shrug... ]  Floating-point timestamps are not perfectly accurate; the
further away you go from 2000-01-01, the less so.  The weird offset from
GMT is probably a function of your local timezone, which you didn't
mention.

			regards, tom lane

In response to

Responses

pgsql-bugs by date

Next:From: Jaime CasanovaDate: 2006-11-21 02:03:15
Subject: Re: BUG #2771: NULL values in FOREIGN KEY fields
Previous:From: Jaime CasanovaDate: 2006-11-21 01:55:57
Subject: Re: BUG #2764: Capital letter in tables or columns not supported

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