Received: from localhost.localdomain (postgresql.org [64.49.215.8]) by localhost (Postfix) with ESMTP id 227FC476AFA for ; Mon, 8 Jul 2002 13:36:24 -0400 (EDT) Mailbox-Line: From narendraa@subexgroup.com Mon Jul 8 13:36:24 2002 Received: from subexgroup.com (unknown [164.164.82.29]) by postgresql.org (Postfix) with ESMTP id 1CDD84763EC for ; Mon, 8 Jul 2002 10:30:56 -0400 (EDT) Received: from narendraa by subexgroup.com with SMTP (MDaemon.v3.5.0.R) for ; Mon, 08 Jul 2002 19:55:30 +0530 Reply-To: From: "Narendra A" To: Subject: is there a way to get hh:mm:ss given seconds Date: Mon, 8 Jul 2002 19:58:50 +0530 Message-ID: <001f01c2268b$c81ae2b0$19ba10ac@narendraa> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0020_01C226B9.E1D31EB0" X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook CWS, Build 9.0.2416 (9.0.2910.0) Importance: Normal X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000 X-Return-Path: narendraa@subexgroup.com X-MDaemon-Deliver-To: pgsql-sql@postgresql.org X-Spam-Status: No, hits=0.0 required=5.0 tests=none version=2.30 X-Spam-Level: X-Archive-Number: 200207/112 X-Sequence-Number: 8491 This is a multi-part message in MIME format. ------=_NextPart_000_0020_01C226B9.E1D31EB0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Sir, 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 eagerly waiting for response. Regards Narendra DISCLAIMER: This email is bound by the terms and conditions described at http://www.subexgroup.com/mail-disclaimer.htm ------=_NextPart_000_0020_01C226B9.E1D31EB0 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable

Sir,

Is there a way in sql such that if I give seconds it should me retur= n me hours:mins:seconds

 <= /span>

Eg. Seconds     = hh:mm:ss

422      =         1:01:02

 <= /span>

eagerly waiting for response.

 <= /span>

Regards

Narendra


DISCLAIMER: This email is bound by the terms and conditions described at http://www.subexgroup.com/mail-disclaimer.htm
------=_NextPart_000_0020_01C226B9.E1D31EB0--