Re: fomatting an interval (resend)

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.

Cheers,
Steve


On Monday 12 May 2003 6:47 pm, Joseph Shraibman wrote:
> playpen=# select version();
>                                 version
> ---------------------------------------------------------------------
>   PostgreSQL 7.3.2 on i686-pc-linux-gnu, compiled by GCC egcs-2.91.66
> (1 row)
>
> playpen=# begin;
> BEGIN
> playpen=# create table timetable (start timestamp, finish timestamp);
> CREATE TABLE
> playpen=# insert into timetable values('2003-05-12 21:37:44.933',
>  '2003-05-12 21:39:14.752'); INSERT 1648889 1
> playpen=# select start, finish, (finish-start),(finish-start)::interval(0)
> from timetable; start          |         finish          |   ?column?   |  
> interval
> -------------------------+-------------------------+--------------+--------
>------ 2003-05-12 21:37:44.933 | 2003-05-12 21:39:14.752 | 00:01:29.819 |
> 00:01:29.819 (1 row)