"Linn Kubler" <LKubler(at)ecw(dot)org> writes:
> Looking at this field in pgadminII and via odbc in something like Visual
> Fox Pro and it looks fine. When I look at it from PSQL, however, it
> looks like the seconds are converted to exponential notation. If that
> makes sense.
Not a lot. Could you *show* us what you're talking about, like
copy-and-paste from a psql session? Also, what does psql's "\d table"
show as the table's schema?
regards, tom lane