| From: | Karel Zak <zakkr(at)zf(dot)jcu(dot)cz> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | "Stefan Waidele jun(dot)" <St(dot)Waidele(dot)jun(at)Krone-Neuenburg(dot)de>, pgsql-novice(at)postgresql(dot)org |
| Subject: | Re: Re: Interval output format |
| Date: | 2001-01-19 13:29:29 |
| Message-ID: | Pine.LNX.3.96.1010119142614.7178A-100000@ara.zf.jcu.cz |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
> "Stefan Waidele jun." <St(dot)Waidele(dot)jun(at)Krone-Neuenburg(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | S Vahey | 2001-01-19 15:13:48 | Postgres, Perl, and Large Objects |
| Previous Message | Stefan Waidele jun. | 2001-01-19 12:27:07 | Re: Front End |