Re:
От | Patrick Fiche |
---|---|
Тема | Re: |
Дата | |
Msg-id | 85058ADF852DD5118FD50002A528A5B6079A7C@SERVEUR обсуждение исходный текст |
Ответ на | ("Jeff MacDonald" <jeff@interchange.ca>) |
Ответы |
Re:
|
Список | pgsql-general |
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
В списке pgsql-general по дате отправления: