Hi, Michael Glaesemann wrote: >> test=# SELECT * from test; >> data >> ---------------------------- >> 1910-01-10 00:00:00+00:19:32 >> 1990-01-10 00:00:00+01 >> (2 rows) > > I suspect your RPMs build PostgreSQL without --enable-integer-datetimes. > Without this configure flag, timestamps are represented as floats, with > all of the imprecision that implies. See the second note below the > Date/Time Types table: > > http://www.postgresql.org/docs/8.2/interactive/datatype-datetime.html#DATATYPE-DATETIME-TABLE
In fact I was thinking to the opposite, but at least one of them didn't use --enable-integer-datetimes. I could understand problems representing microseconds, but not the time zone... Best regards -- Matteo Beccati http://phpadsnew.com http://phppgads.com ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
