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.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