Narender Reddy

Narender Reddy

  • 2k
  • 18
  • 13.2k

Add time in sql server.

May 7 2014 11:56 AM
Hi,
 
I am saving employee worked time from my application to SQL Server.
If suddenly power goes off on pc, then the time worked should not over write, instead it should add to the existing time.
 
Ex:
 
Employee worked for 03:42:50(hh:mm:ss) time.
Suddenly, Power went off and the time should start from the 03:42:50(hh:mm:ss) not from 00:00:00(hh:mm:ss)
 
OR
 
At shift end time the current time and saved [03:42:50(hh:mm:ss)] time must be added.
 
Thank you.