siva nathan

siva nathan

  • 947
  • 828
  • 231.2k

How to calculate extra hours in sql?

Mar 20 2017 7:45 AM
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)