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 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
