Unable to convert date to tm

From: "Joerg Ludwig" <joerg(dot)ludwig(at)hvf-bs(dot)net>
To: <pgsql-bugs(at)postgresql(dot)org>
Subject: Unable to convert date to tm
Date: 2002-09-12 22:47:56
Message-ID: 000001c25aae$70b22e50$0a00a8c0@thunder
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Hello,

I get an error if I try to convert a date before 1970 into a timestamp:

# SELECT (date '1970-01-01')::timestamp;
timestamptz
------------------------
1970-01-01 00:00:00+01
(1 row)

# SELECT (date '1969-12-31')::timestamp;
ERROR: Unable to convert date to tm

I get this error using the RPM postgresql-7.2.1-5 (Red Hat) and
postgresql-7.2.2-1PGDG.
(Btw: What does "tm" stand for?)

On another Linux machine (which should be configured quite similar)
using RPM postgresql-7.2.1-2PGDG there is no error - both SELECT
statements work as expected.

Thx in advance,
Joerg Ludwig

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Kris Jurka 2002-09-12 23:20:23 No dependency between fkey constraint and unique index
Previous Message Tom Lane 2002-09-12 20:37:18 Re: Bug #759: 7.3beta1 DROP COLUMN DEPENDENCY PROBLEM