sql: parse time string

to get time parts from time string
select
lpad(left(mytime,locate(':',mytime)-1),2,'0') as hour,
lpad(substring(mytime,locate(':',mytime)+1,locate(':',mytime,locate(':',mytime)+1)-locate(':',mytime)-1),2,'0') as min,
lpad(right(mytime,length(mytime)-locate(':',mytime,locate(':',mytime)+1)),2,'0') as sec
from mytable;