how to update stored hh:mm value to hh:mm:ss in mysql database, the column datatype is String?

i have stored data in the database with String datatype as
10:56,
10:30:89
like this, now is it possible to convert all the data with hh:mm:ss format i.e.
10:30:89
Please help me here


View on Stack Overflow