Re: time interval format srting

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);

The reason PG makes it a bit difficult is because of things like
daylight savings means that a day can be longer, or shorter, than 24
hours.


  Sam