| 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: | Whole Thread | Raw Message | 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 |