Time handling in pgsql. - Mailing list pgsql-general

Hi,

I have a table like so.

create table times (
  start datetime,
  end datetime,
  estimate fload);

I'd like to be able to do something like this

SELECT estimate::timestamp - (end-start) from times;

anyone have some suggestions ?

When i do "select end-start from times" it formats
the text in such a way that it's like this

"1 days 2:33:03:00"

is there a way taht i can cast that to say "x seconds"
or 26:33:03:00 something like that is much more plesant
to parse than the 1 days format.

Thanks.

Jeff.