X-Original-To: pgsql-sql@postgresql.org
Received: from serwer.skawsoft.com.pl (serwer.skawsoft.com.pl [213.25.37.66])
	by postgresql.org (Postfix) with ESMTP id 71548474E53
	for <pgsql-sql@postgresql.org>; Mon, 17 Mar 2003 06:55:44 -0500 (EST)
Received: from klaster.net (ph86.krakow.cvx.ppp.tpnet.pl [217.99.208.86])
	by serwer.skawsoft.com.pl (Postfix) with ESMTP
	id C26276A1E7; Mon, 17 Mar 2003 12:55:45 +0100 (CET)
Message-ID: <3E75B800.7000902@klaster.net>
Date: Mon, 17 Mar 2003 12:56:48 +0100
From: Tomasz Myrta <jasiek@klaster.net>
User-Agent: Mozilla/5.0 (Windows; U; Win 9x 4.90; pl-PL;
 rv:1.3) Gecko/20030312
X-Accept-Language: pl, en-us, en
MIME-Version: 1.0
To: Rajesh Kumar Mallah <mallah@trade-india.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: Formatting intervals..
References: <200303171717.25857.mallah@trade-india.com>
In-Reply-To: <200303171717.25857.mallah@trade-india.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 8bit
X-Archive-Number: 200303/390
X-Sequence-Number: 12429

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