Problem with Now()?
От | Linn Kubler |
---|---|
Тема | Problem with Now()? |
Дата | |
Msg-id | sd5acdf1.073@gw1.inet.ecw.org обсуждение исходный текст |
Ответы |
Re: Problem with Now()?
|
Список | 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
В списке pgsql-general по дате отправления: