functions for date parsing. - Mailing list pgsql-general

From Jeff MacDonald
Subject functions for date parsing.
Date
Msg-id HIEGJGDMNIKAMPPDEKBNOEELCAAA.jeff@tsunamicreek.com
Whole thread Raw
Responses Re: functions for date parsing.  (Robert Treat <rtreat@webmd.net>)
List 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.



pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: SQL server application porting headache
Next
From: Tom Lane
Date:
Subject: Re: Table name length (maximum identifier length)