> sample=> select age(now()::date,'1990-01-01'::date);
> -------------------------------
> 12 years 5 mons 22 days 23:00
> within postgres, how can i parse this to somethig like
> 12 years 5 months
lockhart=# select date_trunc('month',
age(now()::date,'1990-01-01'::date));
-----------------
12 years 5 mons
to_char() will probably do what you need also.
- Thomas