psycopg2 rounds unix time

Luis P. Mendes luis_lupe2XXX at netvisaoXXX.pt
Sun Feb 5 21:05:24 EST 2006


-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Hi,

I've inserted a couple hundred rows in a table in Postgres via psycopg2.

The first field of each row is a certain unix time (since epoch) when an
event occured.
When I try to access that database with psycopg2, I get rounded values
for the unix time field.

example:
unix time inserted at first row: 1138839839.64456
unix time as retrieved in psql: 1.13884e+09
unix time retrieved by psycopg2: 1138840000.0

Is this a bug?

I'm using:
Python 2.3.5
in a Debian Sarge box
PostgreSQL 7.4.7
psycopg2-2.0b6

Luis P. Mendes
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.1 (GNU/Linux)
Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org

iD8DBQFD5q7kHn4UHCY8rB8RAvh0AJ4nr6239OT6vweUVEF3Htq8smaCJQCgoVnY
NZXZdAyq9UmNXdlOxtwN2y8=
=ZawE
-----END PGP SIGNATURE-----



More information about the Python-list mailing list