2
Reply

How to calculate extra hours in sql?

siva nathan

siva nathan
Mar 20 2017 7:45 AM
195
di have a table like this 
 empid logintime logouttime attdate
 1 8.15am 18.00pm 01-01-17
 2 8.15am    20.00pm 02-01-17
 2 8.15am 18.00pm 03-01-17
 empid OTHours
 1 0
 2 2
when oneday present hour is greater than 8 hours means calculate OT hours


  

Answers (2)
Next Recommended Forum