sql - SqlDbType.Time overflow. Value is out of range -

i want store time in table , take time(7) datatype storing time.

when subtract 2 datetime, got "1.18:36:36.7484253" value in timespan variable.

but problem when insert value in table got error.

sqldbtype.time overflow.  value '1.18:36:36.7484253' out of range.  must between 00:00:00.0000000 , 23:59:59.9999999 

i knew error , question type of datatype use type of value storing time.

i using sql server 2008 , c#.

to resolve problem, need following:

hi, need create new timespan variable.

//////// calculation timestamp //////////                  datetime fechaaux       = datetime.now;                 datetime fechaingresoam = new datetime(fechaaux.year, fechaaux.month, fechaaux.day,  8, 30, 00);                   timespan auxingresoam   = ingresoam.subtract(fechaingresoam);                 timespan resultadoretrasoingresoam = new timespan(auxingresoam.hours, auxingresoam.minutes, auxingresoam.milliseconds);                    command.parameters.add(new sqlparameter("@retraso_ingreso_am", sqldbtype.time));                 command.parameters["@retraso_ingreso_am"].value = resultadoretrasoingresoam;                  command.executenonquery(); 

it work expect.