Horton

Re: fomatting an interval (resend)

Joseph Shraibman <jks@selectacast.net>

View thread
From: jks@selectacast.net
To: Steve Crawford <scrawford@pinpointresearch.com>
Cc: PostgreSQL General <pgsql-general@postgresql.org>
Date: 2003-05-13T17:41:42Z
Lists: pgsql-hackers 
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.