Re: Does anyone use TO_CHAR(INTERVAL)? - Mailing list pgsql-sql

From Bruno Wolff III
Subject Re: Does anyone use TO_CHAR(INTERVAL)?
Date
Msg-id 20030326044356.GA18525@wolff.to
Whole thread Raw
In response to Re: Does anyone use TO_CHAR(INTERVAL)?  (Tomasz Myrta <jasiek@klaster.net>)
Responses Re: Does anyone use TO_CHAR(INTERVAL)?
List pgsql-sql
On Tue, Mar 25, 2003 at 20:24:55 +0100, Tomasz Myrta <jasiek@klaster.net> wrote:
> Uz.ytkownik Josh Berkus napisa?:
> 
> It looks it could be useful to display how much time is left for
> scheduling cases, but as I wrote few threads ago - displaying intervals
> longer than one month is useless without specific date.

That isn't true. Intervals have two parts. One is time difference in
fixed time and the other is a difference in months. You could display
both parts when they are both nonzero.

I haven't found the documenation too specific on which part gets added
first (and this does make a difference in some cases).



pgsql-sql by date:

Previous
From: Tomasz Myrta
Date:
Subject: Re: Does anyone use TO_CHAR(INTERVAL)?
Next
From: Karel Zak
Date:
Subject: Re: Does anyone use TO_CHAR(INTERVAL)?