Re: to_char(interval, text) deprecated in future - how do we get consistent interval output without it?

On Fri, Jan 14, 2005 at 11:36:26 -0800,
  SCassidy@overlandstorage.com wrote:
> I saw the note in the docs that to_char(interval, text) is deprecated, and
> will be removed.  I searched the archives and saw more mentions of this,
> but no real explanation as to how it is planned for us to get consistent
> output formatting when querying a column containing interval data.

You can use EXTRACT.