Re: time interval format srting - Mailing list pgsql-general

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, slightly
embarrassed that I used the ugly form of interval literals, it looks
prettier to me as:

  SELECT justify_interval(90061 * INTERVAL '1 second');

Ah well!


  Sam