Re: Formatting intervals..

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