Formatting Text Field As HH:MM:SS

I am having to Cast() a Text datatype to a TIME datatype. THe issue I’m running into is when the results display i’m loosing the hh:mm:ss format. The syntax I am using is Select SUM(CAST(salestime As Time)) From testData; How do I display my query results in hh:mm:ss format? I also tried to use this syntax SUM(Cast(Time_Format(salesTime, "%h, %i, %s") As Time)) but that is returning a whole number

Go to Source
Author: jamesMandatory