Message-ID: <3E80AD07.5000005@klaster.net>
Date: Tue, 25 Mar 2003 20:24:55 +0100
From: Tomasz Myrta <jasiek@klaster.net>
User-Agent: Mozilla/5.0 (Windows; U; Win 9x 4.90; pl-PL;
 rv:1.3) Gecko/20030312
MIME-Version: 1.0
To: Josh Berkus <josh@agliodbs.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: Does anyone use TO_CHAR(INTERVAL)?
References: <200303250931.27351.josh@agliodbs.com>
In-Reply-To: <200303250931.27351.josh@agliodbs.com>
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit

Uz.ytkownik Josh Berkus napisa?:
> Folks,
> 
> We're discussing the behavior of the current "to_char(interval)" function on 
> HACKERS.   Does anyone on this list use the current behavior?   Please speak 
> up, as we're trying to figure out what backward compatibility needs to be 
> maintained.
> 
> PLEASE NOTE:  This is only to_char() for INTERVAL values, NOT for dates, 
> timestamp, or numeric!
In my projects intervals are always related to some dates when
displaying them, so I use to_char(date+interval).

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.

Anyway, maybe it should be left for future use, but without patterns
related to date, or maybe with DDD only?

Regards,
Tomasz Myrta