Advertisement
Virajsinh

MySQL Time Difference Duity in And Duty Out Query

Mar 23rd, 2024
844
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 0.13 KB | Source Code | 0 0
  1. SELECT *, SEC_TO_TIME(SUM(TIME_TO_SEC(TIMEDIFF(duty_out, duty_in)))) AS time_difference FROM `timesheet` GROUP BY employee_id, date;
Tags: sql mysql
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement