Horton

Re: fomatting an interval (resend)

Dennis Gearon <gearond@cvc.net>

View thread
From: Dennis Gearon <gearond@cvc.net>
To: jks@selectacast.net
Cc: Steve Crawford <scrawford@pinpointresearch.com>, PostgreSQL General <pgsql-general@postgresql.org>
Date: 2003-05-13T22:06:04Z
Lists: pgsql-hackers 
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
>