Re:

You could try
SELECT age( '1995-01-01', CAST( birthdate AS varchar ) )FROM users

Patrick

-----Original Message-----
From: pgsql-general-owner@postgresql.org
[mailto:pgsql-general-owner@postgresql.org]On Behalf Of Jeff MacDonald
Sent: Wednesday, October 09, 2002 4:42 PM
To: Postgres List
Subject: [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@interchange.ca
  ---

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster