SEC_TO_TIME « Date Time « SQL / MySQL






  1. SQL / MySQL
  2. Date Time
  3. SEC_TO_TIME
1.Use SEC_TO_TIME to make time more understandable
2.SEC_TO_TIME(MOD(TIME_TO_SEC(t1) + TIME_TO_SEC(t2), 86400))
3.SEC_TO_TIME( ) converts the equivalent number of seconds to a TIME value
4.To convert the interval to a TIME value, pass it to SEC_TO_TIME( ):