Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id E49A79F999C for ; Sun, 16 Sep 2007 08:01:02 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 76525-03 for ; Sun, 16 Sep 2007 08:00:59 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from ns1.officenet.no (vpn.officenet.no [193.212.174.13]) by postgresql.org (Postfix) with ESMTP id 4FAA09F9629 for ; Sun, 16 Sep 2007 08:00:59 -0300 (ADT) Received: from [84.48.119.79] (helo=andreak-laptop.local) by ns1.officenet.no with esmtpsa (TLS-1.0:DHE_RSA_AES_256_CBC_SHA1:32) (Exim 4.63) (envelope-from ) id 1IWrrw-0002Nj-F0 for pgsql-sql@postgresql.org; Sun, 16 Sep 2007 13:00:55 +0200 From: Andreas Joseph Krogh Organization: OfficeNet AS To: pgsql-sql@postgresql.org Subject: Format intervall as hours/minutes etc Date: Sun, 16 Sep 2007 13:00:53 +0200 User-Agent: KMail/1.9.6 MIME-Version: 1.0 Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: quoted-printable Content-Disposition: inline Message-Id: <200709161300.53257.andreak@officenet.no> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200709/115 X-Sequence-Number: 29328 Hi all. Any hint on how to format this interval as number of hour/seconds e= tc? select age('2007-09-22 17:00'::timestamp, '2000-02-20 18:00'::timestamp); age =2D------------------------------ 7 years 7 mons 1 day 23:00:00 =2D-=20 Andreas Joseph Krogh Senior Software Developer / Manager =2D-----------------------+---------------------------------------------+ OfficeNet AS | The most difficult thing in the world is to | Karenslyst All=C3=A9 11 | know how to do a thing and to watch | PO. Box 529 Sk=C3=B8yen | somebody else doing it wrong, without | 0214 Oslo | comment. | NORWAY | | Tlf: +47 24 15 38 90 | | =46ax: +47 24 15 38 91 | | Mobile: +47 909 56 963 | | =2D-----------------------+---------------------------------------------+