On Fri, Jan 14, 2005 at 11:36:26 -0800, SCassidy@xxxxxxxxxxxxxxxxxxx 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. ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster