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

From Karel Zak
Subject Re: Re: Interval output format
Date
Msg-id Pine.LNX.3.96.1010119142614.7178A-100000@ara.zf.jcu.cz
Whole thread Raw
In response to Re: Re: Interval output format  (Tom Lane <tgl@sss.pgh.pa.us>)
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.)

 For 7.1 it's really too late. For 7.2 I will speculate about it - first
I must explore intervals inwards.

            Karel


pgsql-novice by date:

Previous
From: Rick Jones
Date:
Subject: Inserting TEXT with multiple lines
Next
From: Tom Lane
Date:
Subject: Re: Inserting TEXT with multiple lines