Thread: functions for date parsing.

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.

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.
>

> 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

Perfect ! Thanks.

> -----Original Message-----
> From: Robert Treat [mailto:rtreat@webmd.net]
> Sent: Monday, June 24, 2002 4:34 PM
> To: Jeff MacDonald
> Cc: Postgres List
> Subject: Re: [GENERAL] 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.
> >
>
>
>