Mgiyuk

Mysql convert time to sec then insert into table using the command : SELECT TIME_TO_SEC(timing) FROM chrono SELECT TIME_TO_SEC(timing) FROM chrono I would like to convert the timing column format from hh:mm:ss to seconds then insert results into another table called timing_in_seconds . timing hh:mm:ss seconds timing_in_seconds could you please help achieve this operation? Can you share some sample data and the result you're trying to get? The question is a bit unclear, at least to me – Mureinik Jun 29 at 11:03 @Mureinik Thank you for the feedback. – Rootinshell Jun 29 at 11:05 are we to understand that timing is a varchar column? – ADyson...