How To time(7) data type in sql server 2008 r2 insert this 36:46 value in c#
Example:
Insert into Accounts_DailyAttendance(UserID,UserName,ShiftStart,ShiftEnd,ProcessDate,Punch1,
LateIn,OutPunch,EarlyOut,Overtime_HHMM,FirstHalf,SecondHalf)
values('1001','SENTHILKUMAR R','09:00','20:00','5/2/2014 12:00:00 AM','5/2/2014 4:44:00 PM','0','5/2/2014 8:23:00 PM','0','30:46','PR','PR')
This Insertdata Overtime_HHMM values is 30:46 but this value not insert,so how to this 30:46 value insert(time(7)) datatype in sql server2008 R2
Thanks