Skip to content

Searcharticlesvideosblogsforumsinterview questionsarticles

CSharp TV
Videos
Tech
Articles
Blogs
News
Forums
Books
Events

Article
Blog
Video
Ebook
Interview Question

Loading

Upcoming Events

23 NOV
AI Agents Conference 2026 - 3rd Edition

Latest Forum Questions

Repair MS Outlook PST file issue
Chemline Dorno2d ago2
CrystalDecisions.CrystalReports.Engine
Ramco Ramco3d ago0
winform task
Nandini Sonawane4d ago0
How to load 5000 data in Power Apps gallery
Ismail Sayyad9d ago1
Error converting data type nvarchar to numeric
David Godistei9d ago1

About Us Contact Us Privacy Policy Terms Brand Guidelines Partners C# Tutorials Consultants Ideas Report A Bug FAQs Sitemap Stories CSharp TV DB Talks Web3 Universe Jumpstart Blockchain

©2026 C# Corner.

All contents are copyright of their authors.

How to calculate extra hours in sql?

Home
Forums
Learn iOS Programming

How to calculate extra hours in sql?

siva nathan

siva nathan

9yAsked Mar 20, 2017, 7:45 AM805Learn iOS Programming

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

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Sign in to answer this question

It is the same account you read, post and publish with — and you will come straight back to this page.

Sign in Create an account

Rathrola Prem Kumar9y ago
i Siva,

SELECT DATEDIFF(MINUTE, '11:10:10' , '11:20:00') AS MinuteDiff
You will get MInuteDiff here right?, then if MinuteDiff is Greater than 480min then consider it has OT..

For Reference:
https://msdn.microsoft.com/en-us/library/ms189794.aspx

If this answer helpful to you, then mark it as answered :)
+1
Ramesh Palanivel9y ago
Hi Siva,

Just write a trigger to update the OTHours while inserting logout time in Employeeentery table.

create another two column which saves the time login and logout values.

create the calculation in trigger and save the result in OTEmployee table with date
0