On Tue, Nov 4, 2008 at 10:53 AM, Scott Marlowe <[EMAIL PROTECTED]> wrote: > On Tue, Nov 4, 2008 at 10:06 AM, Joao Ferreira gmail > <[EMAIL PROTECTED]> wrote: >> Hello, >> >> I've been searching the docs on a simple way to convert a time >> _duration_ in seconds to the format dd:hh:mm:ss, but I can't find it. >> >> 90061 --> 1d 1h 1m 1s >> >> (90061=24*3600+3600+60+1) > > select number*interval '1 sec';
OK, that just gives hours:minutes:seconds. You can add and subtract the same timestamp to get something like an interval select ((9084000*interval '1 sec')+timestamp '2008-01-01')-timestamp '2008-01-01'; -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general