Re: psycopg2 rounds unix time [solved]

2006-02-06 Thread Luis P. Mendes
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 |> example: |> unix time inserted at first row: 1138839839.64456 |> unix time as retrieved in psql: 1.13884e+09 |> unix time retrieved by psycopg2: 113884.0 | Note: When timestamp values are stored as double precision | floating-point numbers (cu

Re: psycopg2 rounds unix time

2006-02-05 Thread Steve Holden
Luis P. Mendes wrote: > -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 psy

psycopg2 rounds unix time

2006-02-05 Thread Luis P. Mendes
-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 t