Received: from ciderbox.stanaway.net (ciderbox.stanaway.net [170.76.50.98]) by postgresql.org (Postfix) with ESMTP id 4C6634775FA for ; Tue, 9 Jul 2002 10:58:45 -0400 (EDT) Received: by ciderbox.stanaway.net (Postfix, from userid 1000) id 03860929A2; Tue, 9 Jul 2002 09:58:17 -0500 (CDT) Subject: Re: is there a way to get hh:mm:ss given seconds From: David Stanaway To: narendraa@subexgroup.com Cc: pgsql-sql@postgresql.org In-Reply-To: <001f01c2268b$c81ae2b0$19ba10ac@narendraa> References: <001f01c2268b$c81ae2b0$19ba10ac@narendraa> Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="=-QBKc/KhhYv52wciYuYo4" X-Mailer: Ximian Evolution 1.0.7 Date: 09 Jul 2002 09:58:17 -0500 Message-Id: <1026226697.29753.22.camel@ciderbox> Mime-Version: 1.0 X-Archive-Number: 200207/115 X-Sequence-Number: 8494 --=-QBKc/KhhYv52wciYuYo4 Content-Type: text/plain Content-Transfer-Encoding: quoted-printable On Mon, 2002-07-08 at 09:28, Narendra A wrote: > Sir, > Is there a way in sql such that if I give seconds it should me return me > hours:mins:seconds >=20 > Eg. Seconds hh:mm:ss > 422 1:01:02 scratch=3D# SELECT 422::interval; interval=20 ---------- 00:07:02 (1 row) scratch=3D# \q dstanawa@ciderbox:~$ bc -l 7*60+2 422 I don't know where you got 1:01:02 from. -- David Stanaway --=-QBKc/KhhYv52wciYuYo4 Content-Type: application/pgp-signature; name=signature.asc Content-Description: This is a digitally signed message part -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.0.7 (GNU/Linux) iQEXAwUAPSr6Cb6yIDFGeSAyFAKrQAP/fYud73NSOB5yEJGzvGN30aB7ZiTszWn6 9MDaiECmIKy9XSg8bGkikZCY/acgS0Ww7K3R55n/0kW3a1KWqnqhnLc1gdX54Tok 7BGqA0vmmiz9KGaA3D9KypGc7OOVol0QAUjWskafwc9XxoWY7jN4xnxDUcNSVZRW vb/mHaTOzrgEAMBPpvj0qQgw1t8LF4JvLJzYpkOTXYFhqgyjgRjPpvSI/IVs8qyC FXE1CATDMdI16s2i9E2MZcalh5UHWV1wvuqmBFg44eUjpJSt1o1RXR11ojYAspdL NosrbjX00t2h9v583xH1qMYaitXA1KqBaUrrQeJ9bWQcNyBsPY33/yIk =qBHN -----END PGP SIGNATURE----- --=-QBKc/KhhYv52wciYuYo4--