Hi,
Using PGSQL 7.1 on RH 7.2 and have a problem with a timestamp field with
default of now(). Apparently it sets a bad time when I create a new
record. I found it cause I have a webapp that crashes on these new
records.
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.
I have a second system, virutally identical to this one, and it is not
having the problem. I'm wondering if there is some configuration switch
for the date/time I can set or if this is an indication of corrupted
table or database.
Forgive me I'm having trouble expressing this issue I can tell but any
help is greatly appreciated.
Thanks in advance,
Linn