Re: Formatting intervals..

Uz.ytkownik Rajesh Kumar Mallah napisa?:
> 
> 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.

What about this:
select age('1970-1-1'::date+your_interval,'1970-1-1'::date);

It should give you best result - the answer is true in 75% cases 
(depending on year)

Tomasz