Time Help - Mailing list pgsql-sql

From Brian C. Doyle
Subject Time Help
Date
Msg-id 4.3.2.7.2.20000822063805.095ddf00@pop
Whole thread Raw
List pgsql-sql
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



pgsql-sql by date:

Previous
From: Keith Wong
Date:
Subject: tip: weird parse error for pl/pgsql
Next
From: "Brian C. Doyle"
Date:
Subject: Re: Time Help