I'd be willing to bet that what Linn is seeing is timezone info, which you have
to admit does look a lot like exponential notation.
Seeing the actual table structure for the field, and some sample queries that
fail, would probably be helpful.
Wes
Tom Lane <tgl%sss.pgh.pa.us@interlock.lexmark.com> on 08/14/2002 11:39:35 PM
To: "Linn Kubler" <LKubler%ecw.org@interlock.lexmark.com>
cc: pgsql-general%postgresql.org@interlock.lexmark.com (bcc: Wesley
Sheldahl/Lex/Lexmark)
Subject: Re: [GENERAL] Problem with Now()?
"Linn Kubler" <LKubler@ecw.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
---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org