select convert(datetime,(tc_date+' '+SUBSTRING(tc_time,0,CHARINDEX('-',tc_time))),121) as times2 from im_trainCourse order by times2