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

From Tomasz Myrta
Subject Re: Does anyone use TO_CHAR(INTERVAL)?
Date
Msg-id 3E80AD07.5000005@klaster.net
Whole thread Raw
In response to Does anyone use TO_CHAR(INTERVAL)?  (Josh Berkus <josh@agliodbs.com>)
Responses Re: Does anyone use TO_CHAR(INTERVAL)?  (Bruno Wolff III <bruno@wolff.to>)
List pgsql-sql
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



pgsql-sql by date:

Previous
From: Thomas Good
Date:
Subject: Re: Concatenation Snafu
Next
From: Bruno Wolff III
Date:
Subject: Re: Does anyone use TO_CHAR(INTERVAL)?