2
Answers

How to calculate extra hours in sql?

siva nathan

siva nathan
7y
568
1
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