SELECT 
CONCAT(
SUBSTRING(field_name, -4)
, '-'
, SUBSTRING(field_name, 4, 2)
, '-'
, SUBSTRING(field_name, 1, 2)
) dt
, field_name 
FROM 
table_name;