Convert SQL server yyyyMMddHHmmss format to date format

SELECT MAX (study_id_id) From datax_Status_Time where.

Convert yyyyMMddHHmmss format to date format.

SELECT * From datax_Status_Time where convert (date time, substring (left (time, 8)+ ')+ Substring (time, 9,2)+ ':'+ Substring (time, 11,2)+ ':'+ Substring (time, 13,2), 1,17)< Date add (dd, -1, getdate ()).

SELECT convert (date time, substring (left (time, 8)+ ')+ Substring (time, 9,2)+ ':'+ Substring (time, 11,2)+ ':'+ Substring (time, 13,2), 1,17)
From datax_Status_Time.

SELECT replace+ Substring (time, 9,2)+ ':'+ Substring (time, 11,2)+ ':'+ Substring (time, 13,2), 1,20), 120), -,:
From datax_Status_Time.