date time formatting

Looks like I have 2 accounts copying my above response on t the correct account

Guessing the format

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

from#TempTable