"Randy Solomonson" 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.
reg
The following bug has been logged online:
Bug reference: 5470
Logged by: Randy Solomonson
Email address: pgsqlb...@solomonson.com
PostgreSQL version: 8.4.2
Operating system: Red Hat 4.1.2-46 (64-bit)
Description:EXTRACT(epoch from ...) missing last digit
Details:
Wh