User347430248 posted
Hi malathip,
You had asked that,"Biometric machine punch data log gives staff punching details. The working hours is from 9.00am to 4.30pm. We want to identify the staff, who are coming late or leaving early. "
MS SQL supports time related operations. From your description, I can see that you are using Bio metric scanner.
You need to check that the scanner you are using comes with any SDK or not.
With that SDK, You will be able to read and process data then you can enter those data in your database.
Some of the example of SDK you can get from link below.
C# ZKTeco Biometric Device Getting Started
Regards
Deepak