Re: Problem with Now()?

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(dot)pgh(dot)pa(dot)us(at)interlock(dot)lexmark(dot)com> on 08/14/2002 11:39:35 PM

To: "Linn Kubler" <LKubler%ecw(dot)org(at)interlock(dot)lexmark(dot)com>
cc: pgsql-general%postgresql(dot)org(at)interlock(dot)lexmark(dot)com (bcc: Wesley
Sheldahl/Lex/Lexmark)
Subject: Re: [GENERAL] Problem with Now()?

"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

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo(at)postgresql(dot)org