SEC_TO_TIME() convert to java.sql.Time error
- by chun
hi
I have a aggregate column present the microsecond, a report(with jasper) have to show HH:mm:ss of this indicator
What I did is using SEC_TO_TIME(sum(col)/1000) , but when mapping to java.sql.Time, i doesn't work when the value of hour in result pass over 24(ex:36:33:33)
Then I think another way, not using sec_to_time, just mapping the microsecond as Bigdecimal,
but dunno what java class shoud i use to format date as the default format of hh:mm:ss is limit to 24...?