I have a SQL table as
我有一个SQL表
empid to_day clock_in clock_out late_reason
001Acc 01/04/2016 9:12:08 18:33:57 Office work
001Acc 02/04/2016 10:12:08 19:33:57 Home work
001Acc 03/04/2016 11:12:08 20:33:57 Sick
001Acc 04/04/2016 10:12:08 19:53:57 Car disorder
001Acc 05/04/2016 13:12:08 19:33:57 Hospital
empid to_da