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

From: Bruno Wolff III <bruno(at)wolff(dot)to>
To: SCassidy(at)overlandstorage(dot)com
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: to_char(interval, text) deprecated in future - how do we get consistent interval output without it?
Date: 2005-01-15 09:13:13
Message-ID: 20050115091313.GB27243@wolff.to
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Fri, Jan 14, 2005 at 11:36:26 -0800,
SCassidy(at)overlandstorage(dot)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.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Bruno Wolff III 2005-01-15 09:33:07 Re: serial increments on failed insert
Previous Message PFC 2005-01-15 08:02:12 Re: OID Usage