Re: functions for date parsing.

> 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