On Tue, Nov 4, 2008 at 10:53 AM, Scott Marlowe <scott.marlowe@xxxxxxxxx> wrote: > On Tue, Nov 4, 2008 at 10:06 AM, Joao Ferreira gmail > <joao.miguel.c.ferreira@xxxxxxxxx> 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@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
