convert(date,LEFT(Dt_Tm, 11) + ' ' + SUBSTRING(Dt_Tm, 13, 2) + ':' + RIGHT(Dt_Tm, 2) + ':00')
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)