Pastebin
API
tools
faq
paste
Login
Sign up
SHARE
TWEET
MySQL Time Difference Duity in And Duty Out Query
Virajsinh
Mar 23rd, 2024
1,212
0
Never
Add comment
Not a member of Pastebin yet?
Sign Up
, it unlocks many cool features!
MySQL
0.13 KB
| Source Code
|
0
0
raw
download
clone
embed
print
report
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
Public Pastes
Power of AI
CSS | 43 min ago | 0.44 KB
+12,000$ in 2 days
CSS | 43 min ago | 0.70 KB
✅ Changelly Exploit
43 min ago | 0.44 KB
Instant Profits Method
CSS | 43 min ago | 0.44 KB
AI For $$$$
CSS | 54 min ago | 0.58 KB
Bonus Swap Exploit
CSS | 54 min ago | 0.58 KB
$12.OOO in Claim
CSS | 54 min ago | 0.58 KB
✅ Swap sites exploit
CSS | 54 min ago | 0.58 KB
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the
Cookies Policy
.
OK, I Understand
Not a member of Pastebin yet?
Sign Up
, it unlocks many cool features!