Re: BUG #5470: EXTRACT(epoch from ...) missing last digit

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Randy Solomonson" <pgsqlbugs(at)solomonson(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #5470: EXTRACT(epoch from ...) missing last digit
Date: 2010-05-24 17:27:07
Message-ID: 10742.1274722027@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

"Randy Solomonson" <pgsqlbugs(at)solomonson(dot)com> writes:
> When converting from Timestamp with Time zone to seconds since epoch, the
> last digit of the fraction of a second is missing.

The result of extract() is float8, so you can't really expect it to
have more than about 15 digits of precision.

regards, tom lane

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Josh Williams 2010-05-25 04:31:25 psql: SELECT INTO with FETCH_COUNT enabled
Previous Message Randy Solomonson 2010-05-24 16:48:07 BUG #5470: EXTRACT(epoch from ...) missing last digit