Re: Problem with Now()? - Mailing list pgsql-general

From Tom Lane
Subject Re: Problem with Now()?
Date
Msg-id 19292.1029382775@sss.pgh.pa.us
Whole thread Raw
In response to Problem with Now()?  ("Linn Kubler" <LKubler@ecw.org>)
List pgsql-general
"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

pgsql-general by date:

Previous
From: "Linn Kubler"
Date:
Subject: Problem with Now()?
Next
From: Jean-Christian Imbeault
Date:
Subject: EPCOH: extract returns millisecs too?