From: "Jeff MacDonald" <jeff(at)interchange(dot)ca>
To: "Postgres List" <pgsql-general(at)postgresql(dot)org>
Subject:
Date: 2002-10-09 14:41:49
Message-ID: HIEGJGDMNIKAMPPDEKBNEEIACCAA.jeff@interchange.ca
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi Folks,

This problem is occuring on pgsql 7.2.1 as well as 7.2.2.
I have nothing to say except this is VERY weird. Is there something
evil about 1930-04-27 ?

xxx=>SELECT id,birthdate FROM users WHERE id IN (343,345);
id | birthdate
-----+------------
343 | 1930-04-27
345 | 1963-09-15
(2 rows)

xxx=> SELECT age('1995-01-01',birthdate) FROM users where id =343;
ERROR: Unable to convert date to tm
xxx=> SELECT age('1995-01-01',birthdate) FROM users where id =345;
age
-------------------------------
31 years 3 mons 16 days 01:00
(1 row)

---
Jeff MacDonald
Interchange Technologies
jeff(at)interchange(dot)ca
---

Responses

  • Re: at 2002-10-09 14:46:19 from Darren Ferguson
  • Re: at 2002-10-10 04:38:29 from Tom Lane

Browse pgsql-general by date

  From Date Subject
Next Message Darren Ferguson 2002-10-09 14:46:19 Re:
Previous Message Sandeep Chadha 2002-10-09 13:42:56 Re: [GENERAL] Hot Backup