Formatting intervals.. - Mailing list pgsql-sql

From Rajesh Kumar Mallah
Subject Formatting intervals..
Date
Msg-id 200303171717.25857.mallah@trade-india.com
Whole thread Raw
Responses Re: Formatting intervals..
List pgsql-sql
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..


regds
mallah.




-- 
Rajesh Kumar Mallah,
Project Manager (Development)
Infocom Network Limited, New Delhi
phone: +91(11)6152172 (221) (L) ,9811255597 (M)

Visit http://www.trade-india.com ,
India's Leading B2B eMarketplace.


pgsql-sql by date:

Previous
From: Christoph Haller
Date:
Subject: Re: Create function statement with insert statement
Next
From: Tomasz Myrta
Date:
Subject: Re: Formatting intervals..