Formatting an Interval - Mailing list pgsql-sql

From Jamison Roberts
Subject Formatting an Interval
Date
Msg-id 238e52230412310837183fb730@mail.gmail.com
Whole thread Raw
Responses Re: Formatting an Interval
List pgsql-sql
All of the functions that i've looked at seem to only extract parts
from Intervals.  What I need to do is to format the interval.  For
instance, I have a Interval with the value 1 day 07:57:52.  I would
like that in HH:MM:SS.  So in the example the output would be
31:57:52.

How can this be done?


pgsql-sql by date:

Previous
From: Jose Mendoza
Date:
Subject: Function in C++
Next
From: Michael Fuhr
Date:
Subject: Re: Formatting an Interval