From: | "Linn Kubler" <LKubler(at)ecw(dot)org> |
---|---|
To: | <pgsql-general(at)postgresql(dot)org> |
Subject: | Problem with Now()? |
Date: | 2002-08-15 02:38:22 |
Message-ID: | sd5acdf1.073@gw1.inet.ecw.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 2002-08-15 02:44:54 | Re: little psql additions |
Previous Message | Varsha Agarwal | 2002-08-15 00:58:27 | Installing postgressql on windows |