000 results (0.47 seconds) Search Results 12.7 Date and Time Functions – MySQL dev.mysql.com › … › 12 Functions and Operators See Section 11.3

convert time in seconds to HH:MM:SS format in MySQL?

by

You can use MySQL function SEC_TO_TIME(). Example: SELECT SEC_TO_TIME(2378); Output is: 00:39:38