Received: from blount.mail.mindspring.net (blount.mail.mindspring.net [207.69.200.226]) by hub.org (8.10.1/8.10.1) with ESMTP id e7MELWT71103 for ; Tue, 22 Aug 2000 10:21:32 -0400 (EDT) Received: from hbg-b467.mindspring.com (fw-5-e3.atl2.mindspring.net [207.69.162.92]) by blount.mail.mindspring.net (8.9.3/8.8.5) with ESMTP id KAA27242; Tue, 22 Aug 2000 10:21:28 -0400 (EDT) Message-Id: <4.3.2.7.2.20000822101650.03985b20@pop> X-Sender: bcdoyle@pop X-Mailer: QUALCOMM Windows Eudora Version 4.3.2 Date: Tue, 22 Aug 2000 10:21:24 -0400 To: Mark Volpe From: "Brian C. Doyle" Subject: Re: Time Help Cc: pgsql-sql@postgresql.org In-Reply-To: <39A28640.DF45460B@epamail.epa.gov> References: <4.3.2.7.2.20000822063805.095ddf00@pop> Mime-Version: 1.0 Content-Type: text/plain; charset="us-ascii"; format=flowed X-Archive-Number: 200008/222 Mark, I tried that and had to change it to: SELECT '0:00:00'::timespan + '02:10:06'::timespan; To get any response. the response i got was @ 2 hours 10 mins 6 secs Still in the wrong format If is use : SELECT '0:00:00'::time + '02:10:06'::timespan; It get No such function 'time_timespan' with the specified attributes So i guess what I want to do is convert a timespan into time How would I do that? At 09:55 AM 8/22/00 -0400, Mark Volpe wrote: >I'm not sure at all what you are asking, but I'm thinking you're trying to >convert a "timespan" to a "time". Try adding it to a time like this: >SELECT '0:00:00'::time + '02:10:06'::timespan; > >Mark > >"Brian C. Doyle" wrote: > > > > 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