Re: fomatting an interval (resend) - Mailing list pgsql-general

From jks@selectacast.net
Subject Re: fomatting an interval (resend)
Date
Msg-id Pine.LNX.4.44.0305131341190.7420-100000@p1.selectacast.net
Whole thread Raw
In response to Re: fomatting an interval (resend)  (Steve Crawford <scrawford@pinpointresearch.com>)
Responses Re: fomatting an interval (resend)  (Dennis Gearon <gearond@cvc.net>)
List pgsql-general
On Tue, 13 May 2003, Steve Crawford wrote:

> How about:
>
> select to_char(finish-start, 'HH24:MI:SS') from timetable;
>  to_char
> ----------
>  00:01:29
>
> This won't work if the interval is > 24 hours - you would have to add
> formatting to allow for days.
>

... which is exactly my problem.


pgsql-general by date:

Previous
From: Josh Berkus
Date:
Subject: OpenVMS Port?
Next
From: "Dann Corbit"
Date:
Subject: Re: OpenVMS Port?