Re: Formatting intervals..

Yes i realize what your are saying.
its not a valid calculation.

actually my original problem is
that i have to display this duration
in a human friendly way in my website.

shud i divide by 30 and tell the customer
that its approximate ?

but even that sounds amatuerish to me.
hope i will be able to explain the marketing
guys ;-)

regds
mallah.

On Monday 17 Mar 2003 5:26 pm, Tomasz Myrta wrote:
> Uz.ytkownik Rajesh Kumar Mallah napisa?:
> > Hi,
> >
> > Is it possible to customize interval display.
> >
> > eg,
> >
> > tradein_clients=# SELECT cast ('10-10-1999'::timestamp - '1-1-1999'::timestamp AS interval);
> > +----------+
> > | interval |
> > +----------+
> > | 282 days |
> > +----------+
> > (1 row)
> >
> > can i display it in months and days..
> It doesn't make sense. You don't have whole date, so how long should
> month be? 28? 29? 30? 31?
>
> Regards,
> Tomasz Myrta
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org
>
>

--
Rajesh Kumar Mallah,
Project Manager (Development)
Infocom Network Limited, New Delhi
phone: +91(11)6152172 (221) (L) ,9811255597 (M)

Visit http://www.trade-india.com ,
India's Leading B2B eMarketplace.