Re: Formatting intervals..

> >
> > 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?
>
It does. As long the months between January and October are.
So
select age ('10-10-1999'::timestamp , '1-1-1999'::timestamp ) ;     age
---------------9 mons 9 days
(1 row)

Regards, Christoph