From: | "Jeff MacDonald" <jeff(at)tsunamicreek(dot)com> |
---|---|
To: | "Robert Treat" <rtreat(at)webmd(dot)net> |
Cc: | "Postgres List" <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: functions for date parsing. |
Date: | 2002-06-25 12:58:44 |
Message-ID: | HIEGJGDMNIKAMPPDEKBNMEFCCAAA.jeff@tsunamicreek.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Perfect ! Thanks.
> -----Original Message-----
> From: Robert Treat [mailto:rtreat(at)webmd(dot)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.
> >
>
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2002-06-25 13:34:59 | Re: Urgent: Tuning strategies? |
Previous Message | Mourad EL HADJ MIMOUNE | 2002-06-25 12:52:18 | Re: Table name length (maximum identifier length) |