date time formatting

Alternative,

select mdate,
cast(substring(mdate,5,2) + '/' +
substring(mdate,7,2)  + '/' +
substring(mdate,1,4)  + ' ' +
substring(mdate,9,2)  + ':' +
substring(mdate,11,2)  + ':' +
substring(mdate,13,2) as datetime) newMdate
from #TempTable

---

Regards, RSingh