Well worth joining the list. Thanks guys. On Wed, Sep 23, 2009 at 12:48 PM, Adam Rich <adam.r@xxxxxxxxxxxxx> wrote: > Shane R. Spencer wrote: >> >> I work in VoIP. HMS (Hour/Minute/Second) format appears to be the rule >> when working with call time totals. I admit it makes some reports >> easier to read. >> >> The method I used to convert a int/bigint to HMS (or the standard >> representation of an interval type) is as follows: >> >> select (123456.789::varchar(24) || ' seconds')::interval as HMS; >> hms >> -------------- >> 34:17:36.789 >> >> Is there a less string oriented method of converting seconds as an int >> to an interval? >> >> - Shane >> > > I think this is cleaner/faster: > > > select interval '1 second' * 123456.789 as HMS; > > hms > -------------- > 34:17:36.789 > > > -Adam > > > > -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
