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