Andreas Kretschmer replied:
> I wrote:
> > How about doing:
> >
> > SELECT justify_interval(90061 * '1 second'::INTERVAL);
>
> Nice, didn't know this function.
Yup, PG does everything! Not sure when I discovered it; also not sure
if I've ever had to use it in anger before. I am, however, sli
Sam Mason <[EMAIL PROTECTED]> schrieb:
> On Tue, Nov 04, 2008 at 05:06:37PM +, 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=
am Tue, dem 04.11.2008, um 17:06:37 + mailte Joao Ferreira gmail folgendes:
> 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)
>
> any id
On Tue, Nov 04, 2008 at 05:06:37PM +, 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 usi
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'
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*
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)
any ideas ?
I've been using to_char and to_timestamp to format dates/timestamps...
but this is diferent...
