Re: Formatting intervals.. - Mailing list pgsql-sql

From Tomasz Myrta
Subject Re: Formatting intervals..
Date
Msg-id 3E75B800.7000902@klaster.net
Whole thread Raw
In response to Formatting intervals..  (Rajesh Kumar Mallah <mallah@trade-india.com>)
Responses Re: Formatting intervals..  (Rajesh Kumar Mallah <mallah@trade-india.com>)
List pgsql-sql
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



pgsql-sql by date:

Previous
From: Rajesh Kumar Mallah
Date:
Subject: Formatting intervals..
Next
From: Christoph Haller
Date:
Subject: Re: Formatting intervals..