Received: from tisch.mail.mindspring.net (tisch.mail.mindspring.net [207.69.200.157]) by hub.org (8.10.1/8.10.1) with ESMTP id e7MAmST78176 for ; Tue, 22 Aug 2000 06:48:28 -0400 (EDT) Received: from hbg-b467.mindspring.com (fw-5-e3.atl2.mindspring.net [207.69.162.92]) by tisch.mail.mindspring.net (8.9.3/8.8.5) with ESMTP id GAA25767 for ; Tue, 22 Aug 2000 06:48:27 -0400 (EDT) Message-Id: <4.3.2.7.2.20000822063805.095ddf00@pop> X-Sender: bcdoyle@pop X-Mailer: QUALCOMM Windows Eudora Version 4.3.2 Date: Tue, 22 Aug 2000 06:47:19 -0400 To: pgsql-sql@postgresql.org From: "Brian C. Doyle" Subject: Time Help Mime-Version: 1.0 Content-Type: text/plain; charset="us-ascii"; format=flowed X-Archive-Number: 200008/221 Hello all, I have a query result of @ 2 hours 10 mins 6 secs and I would like to change that to 02:10:06. Currently the field is listed as "timespan" This allows me to input date as 02:10:06 or 4h 10m 6s or even 2hrs 10 min 6 sec which are all the formats that I will be entering the time formats! How do I convert it into a the format of 02:10:06 Thanks to you all