GROUP BY – Time Math Functions
SELECT
CONCAT(employees.first_name, ' ', employees.last_name) AS Employee,
employees.emp_no,
TIMEDIFF(PBAll.date_time_out, PBAll.date_time_in),
UNIX_TIMESTAMP(PBAll.date_time_out) - UNIX_TIMESTAMP(PBAll.date_time_in),
SEC_TO_TIME(UNIX_TIMESTAMP(PBAll.date_time_out) - UNIX_TIMESTAMP(PBAll.date_time_in))
FROM
PBAll
INNER JOIN
employees
ON
PBAll.emp_no = employees.emp_no
WHERE
PBAll.emp_no = 8159 AND
PBAll.date_time_in >= (now() - INTERVAL 0+12 HOUR) && PBAll.date_time_in < (now() - INTERVAL 0 HOUR)
SELECT
CONCAT(employees.first_name, ' ', employees.last_name) AS Employee,
employees.emp_no,
SEC_TO_TIME(Sum(UNIX_TIMESTAMP(PBAll.date_time_out) - UNIX_TIMESTAMP(PBAll.date_time_in)))
FROM
PBAll
INNER JOIN
employees
ON
PBAll.emp_no = employees.emp_no
WHERE
PBAll.emp_no = 8159 AND
PBAll.date_time_in >= (now() - INTERVAL 0+12 HOUR) && PBAll.date_time_in < (now() - INTERVAL 0 HOUR)
GROUP BY employees.emp_no
