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.
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 |