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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-bugs by date

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