• How about this...

    select Cast(Replace('AUG 28, 2008@11:30:03', '@', ' ') as datetime)