date time formatting

Guessing the format

Selectconvert(datetime,stuff(stuff(stuff(stuff(mdate,13,0,':'),11,0,':'),9,0,':'),7,0,' '))

from#TempTable