[SQL] Time Help

[Brian C. Doyle]

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