title: How to insert time in SQl Server 2005?
body: <p>I am creating windows application .In this I have to subtract two dates .I subtract it successfully  ,I used TimeSpan to get subtracted value.But when I insert it in SQl Server 2005 db, it inserted with starting date i.e. 1/1/1900 and the calculated difference</p>
  
  <p>which format should I use to insert Time only?</p>
  
  <p>Thanks in advance</p>