Postgres Pro
Downloads
Home   >   mailing lists

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

From Bruno Wolff III
Subject Re: to_char(interval, text) deprecated in future - how do we get consistent interval output without it?
Date
Msg-id 20050115091313.GB27243@wolff.to
Whole thread Raw
In response to to_char(interval, text) deprecated in future - how do we get consistent interval output without it?  (SCassidy@overlandstorage.com)
List pgsql-general
Tree view 
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.

pgsql-general by date:

Previous
From: PFC
Date:
Subject: Re: OID Usage
Next
From: Bruno Wolff III
Date:
Subject: Re: serial increments on failed insert