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