Formatting intervals..

From: Rajesh Kumar Mallah <mallah(at)trade-india(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: Formatting intervals..
Date: 2003-03-17 11:47:25
Message-ID: 200303171717.25857.mallah@trade-india.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Tomasz Myrta 2003-03-17 11:56:48 Re: Formatting intervals..
Previous Message Christoph Haller 2003-03-17 11:25:47 Re: Create function statement with insert statement