functions for date parsing.

From: "Jeff MacDonald" <jeff(at)tsunamicreek(dot)com>
To: "Postgres List" <pgsql-general(at)postgresql(dot)org>
Subject: functions for date parsing.
Date: 2002-06-24 14:21:24
Message-ID: HIEGJGDMNIKAMPPDEKBNOEELCAAA.jeff@tsunamicreek.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

sample=> select age(now()::date,'1990-01-01'::date);
age
-------------------------------
12 years 5 mons 22 days 23:00

within postgres, how can i parse this to somethig like

12 years 5 months

Thanks..
Jeff.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Bruce Momjian 2002-06-24 14:39:03 Re: [GENERAL] Idea for the statistics collector
Previous Message Tom Lane 2002-06-24 13:34:44 Re: SQL server application porting headache