Sam Mason <sam@xxxxxxxxxxxxx> schrieb: > On Tue, Nov 04, 2008 at 05:06:37PM +0000, Joao Ferreira gmail wrote: > > 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) > > > > any ideas ? > > > > I've been using to_char and to_timestamp to format dates/timestamps... > > but this is diferent... I want to format time intervals, durations.. > > How about doing: > > SELECT justify_interval(90061 * '1 second'::INTERVAL); Nice, didn't know this function. Andreas -- Really, I'm not out to destroy Microsoft. That will just be a completely unintentional side effect. (Linus Torvalds) "If I was god, I would recompile penguin with --enable-fly." (unknown) Kaufbach, Saxony, Germany, Europe. N 51.05082°, E 13.56889° -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
