How to get time from next date in MySQL
I have table Att_Log like this: Emp_ID Date_Att Time_Att E-0123 2024-01-02 08:05:56 E-0123 2024-01-02 17:02:23 E-0124 2024-01-02 21:55:56 E-0124 2024-01-03 06:02:23 the results I expect is like this: Emp_ID Date In_Time Out_Time E-0123 2024-01-02 08:05:56 17:02:23 E-0124 2024-01-02 21:55:56 06:02:23…