write a pl/pgsql function that outputs the format, based on receiving the interval in seconds.
jks@selectacast.net wrote:
> 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.
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo@postgresql.org so that your
> message can get through to the mailing list cleanly
>