Re: Formatting intervals..

From: Christoph Haller <ch(at)rodos(dot)fzk(dot)de>
To: mallah(at)trade-india(dot)com
Cc: jasiek(at)klaster(dot)net, pgsql-sql(at)postgresql(dot)org
Subject: Re: Formatting intervals..
Date: 2003-03-17 13:03:58
Message-ID: 3E75C7BE.5BFE8C6C@rodos.fzk.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

> >
> > 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?
>
It does. As long the months between January and October are.
So
select age ('10-10-1999'::timestamp , '1-1-1999'::timestamp ) ;
age
---------------
9 mons 9 days
(1 row)

Regards, Christoph

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Rajesh Kumar Mallah 2003-03-17 13:04:54 Re: Formatting intervals..
Previous Message Tomasz Myrta 2003-03-17 11:56:48 Re: Formatting intervals..