Received: from localhost.localdomain (postgresql.org [64.49.215.8]) by localhost (Postfix) with ESMTP id 4AA8E475F29 for ; Tue, 9 Jul 2002 11:19:30 -0400 (EDT) Mailbox-Line: From devin@spamcop.net Tue Jul 9 11:19:30 2002 Received: from glass.dnsart.com (203.141.139.231.user.ad.il24.net [203.141.139.231]) by postgresql.org (Postfix) with ESMTP id 203AE4764E7 for ; Tue, 9 Jul 2002 10:41:31 -0400 (EDT) Received: from localhost ([127.0.0.1]) by glass.dnsart.com with esmtp (Exim 3.36 #1) id 17RwBB-0001AJ-00; Tue, 09 Jul 2002 23:41:25 +0900 Date: Tue, 9 Jul 2002 23:41:23 +0900 (JST) From: Tod McQuillin X-X-Sender: devin@glass.pun-pun.prv To: Narendra A Cc: pgsql-sql@postgresql.org Subject: Re: is there a way to get hh:mm:ss given seconds In-Reply-To: <001f01c2268b$c81ae2b0$19ba10ac@narendraa> Message-ID: <20020709234014.Y68009-100000@glass.pun-pun.prv> MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII X-Spam-Status: No, hits=-3.4 required=5.0 tests=IN_REP_TO version=2.30 X-Spam-Level: X-Archive-Number: 200207/116 X-Sequence-Number: 8495 On Mon, 8 Jul 2002, Narendra A wrote: > Is there a way in sql such that if I give seconds it should me return me > hours:mins:seconds > > Eg. Seconds hh:mm:ss > 422 1:01:02 foo=# select '422 seconds'::interval; interval ---------- 00:07:02 (1 row) -- Tod McQuillin