Re: Select records from next date

[Rick James]

You probably need PRIMARY KEY(attendance_id) in that table.

What if someone starts/ends outside both of those "shifts"? Which shift of which day should it count toward?

You have not examples of someone taking a break mid-shift, so the test case may fail to properly account for such.

    SELECT  fk_employee_id, start_date,
            MIN(in_time), MAX(out_time)
        FROM  (
            SELECT fk_employee_id,
                   DATE(COALESCE(in_time, out_time) -
                           INTERVAL 8 HOUR) AS start_date,
                   in_time,
                   out_time
                FROM sc_attendance
              ) x
        GROUP BY  fk_employee_id, start_date;