X-Original-To: pgsql-sql@postgresql.org Received: from trade-india.com (ns5.trade-india.com [66.234.10.13]) by postgresql.org (Postfix) with SMTP id 335C4475ADE for ; Mon, 17 Mar 2003 06:46:53 -0500 (EST) Received: (qmail 27746 invoked by uid 505); 17 Mar 2003 11:46:43 -0000 Received: from mallah@trade-india.com by ns5.trade-india.com by uid 502 with qmail-scanner-1.15 (uvscan: v4.1.60/v4171. Clear:. Processed in 1.616921 secs); 17 Mar 2003 11:46:43 -0000 Received: from mail-relay.trade-india.com (HELO system67.trade-india-local.com) (203.196.129.235) by ns5.trade-india.com with SMTP; 17 Mar 2003 11:46:41 -0000 From: Rajesh Kumar Mallah Organization: Infocom Network Limited To: pgsql-sql@postgresql.org Subject: Formatting intervals.. Date: Mon, 17 Mar 2003 17:17:25 +0530 User-Agent: KMail/1.5 MIME-Version: 1.0 Content-Disposition: inline Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Message-Id: <200303171717.25857.mallah@trade-india.com> X-Archive-Number: 200303/389 X-Sequence-Number: 12428 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.