Re: Rounding error on extract(epoch ..)

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

Moshe Jacobson <moshe(at)neadwerx(dot)com> writes:
> It seems that extract(epoch ..) does not preserve the entire precision of
> the passed-in timestamp.

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

regards, tom lane

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message kieran.mccusker 2014-01-24 17:01:27 BUG #8956: fedora download does not contain pg_config
Previous Message Moshe Jacobson 2014-01-24 16:40:59 Rounding error on extract(epoch ..)