MySQL-esque sec_to_time() function

From: "George Johnson" <gjohnson(at)jdsc(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Subject: MySQL-esque sec_to_time() function
Date: 2000-12-06 16:27:56
Message-ID: 002c01c05fa1$7d8deb00$0300a8c0@jdsc
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello,

I'm converting from MySQL to PostgreSQL (actually flipping/flopping back) and have a question:

MySQL has a cool function sec_to_time() which converts your number of seconds to hh:mm:ss

I've read thru the mailing lists and am basically trying to implement the following:

MySQL:
select sec_to_time(sum(unix_timestamp(enddate) - unix_timestamp(startdate))) from foo;

PostgreSQL:
select XXX(sum(date_part('epoch',enddate) - date_part('epoch',startdate))) from foo;

I just need to know what XXX is/can be. I've tried a lot of combinations of the documented functions and come up with useless conversions.

Thanks,
George Johnson
gjohnson(at)jdsc(dot)com

PS: i can't find documentation on how to load the functions in contrib. I can compile and
install them O.K., but not sure how to make them load.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Isaac 2000-12-06 16:33:53 localization design for DB structures?
Previous Message Alain Lavigne 2000-12-06 16:23:26 pg_trigger