From: Rajesh Kumar Mallah <mallah@trade-india.com>
To: Tomasz Myrta <jasiek@klaster.net>
Cc: pgsql-sql@postgresql.org
Subject: Re: Formatting intervals..
Date: Mon, 17 Mar 2003 18:34:54 +0530
Message-ID: <200303171834.54623.mallah@trade-india.com> (raw)
In-Reply-To: <3E75B800.7000902@klaster.net>
References: <200303171717.25857.mallah@trade-india.com>
<3E75B800.7000902@klaster.net>
Yes i realize what your are saying.
its not a valid calculation.
actually my original problem is
that i have to display this duration
in a human friendly way in my website.
shud i divide by 30 and tell the customer
that its approximate ?
but even that sounds amatuerish to me.
hope i will be able to explain the marketing
guys ;-)
regds
mallah.
On Monday 17 Mar 2003 5:26 pm, Tomasz Myrta wrote:
> 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
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org
>
>
--
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.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: mallah@trade-india.com, jasiek@klaster.net
Subject: Re: Formatting intervals..
In-Reply-To: <200303171834.54623.mallah@trade-india.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox