Re: Re: Interval output format - Mailing list pgsql-novice

From Tom Lane
Subject Re: Re: Interval output format
Date
Msg-id 6222.979869960@sss.pgh.pa.us
Whole thread Raw
In response to Re: Interval output format  ("Stefan Waidele jun." <St.Waidele.jun@Krone-Neuenburg.de>)
Responses Re: Re: Interval output format
List pgsql-novice
"Stefan Waidele jun." <St.Waidele.jun@Krone-Neuenburg.de> writes:
> At 13:37 18.01.2001 -0500, Tom Lane wrote:
> How can I tell Postgres to return an interval value in an format like
>> hhh:mm?
>>
>> See to_char(),
>> http://www.postgresql.org/devel-corner/docs/postgres/functions-formatting.htm

My mistake :-( ... I thought there was a variant of to_char for
intervals as well as timestamps, but I see there is not.  Karel,
does this seem like it should be added for 7.2?  (Too late for
7.1, I think.)

            regards, tom lane

pgsql-novice by date:

Previous
From: Tom Lane
Date:
Subject: Re: Yikes! Bitten by line length?
Next
From: Tom Lane
Date:
Subject: Re: Re: Interval output format