what is the best way to store time interval in a SQL server database

Posted by oo on Stack Overflow See other posts from Stack Overflow or by oo
Published on 2010-03-07T19:15:35Z Indexed on 2010/03/08 0:30 UTC
Read the original article Hit count: 325

Filed under:
|

i have a table where i want to track time so a valid entry might be:

  • 1 hour 3 mins
  • 47 mins
  • 10 hours
  • 3 mins 14 seconds

what field type is best used for this. i obviously could use varchar . .but i thought there might be something better as i would like to run queries to total the amount of time over a number of records.

© Stack Overflow or respective owner

Related posts about sql-server

Related posts about runtime