select *,SUBSTRING(tc_time,0,CHARINDEX('-',tc_time)) as times2 from table order by tc_date asc,times2 desc