Re: Rounding error on extract(epoch ..)

From: Moshe Jacobson <moshe(at)neadwerx(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: Rounding error on extract(epoch ..)
Date: 2014-01-24 17:56:42
Message-ID: CAJ4CxLmNhHoFATaThraBL8FzPBQUtPTqDFjz6BmrhStupMomAg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

On Jan 24, 2014 11:52 AM, "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:

> The result is float8, so being good to about 16 digits is expected
> behavior.

I see. But how is it that the correct result is returned when I pass the
output of extract straight into to_timestamp?

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message John R Pierce 2014-01-24 18:18:49 Re: BUG #8956: fedora download does not contain pg_config
Previous Message kieran.mccusker 2014-01-24 17:01:27 BUG #8956: fedora download does not contain pg_config