Re: functions for date parsing.

db=# select date_trunc('month',age(now()::date,'1990-01-01'::date));

   date_trunc
-----------------
 12 years 5 mons
(1 row)

Robert Treat

On Mon, 2002-06-24 at 10:21, Jeff MacDonald wrote:
> 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.
>