Problem with Now()?

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

Responses

Browse pgsql-general by date

  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