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.