How do I store a time span value in SQL Server 2008?
I have a string that represents a time duration-
example: 24d 21h 27m
I'm not sure the best way to parse this into a DateTime or equivalent value that I can use in .NET to compare with other DateTime values, and then store in SQLServer -- what SQL data type? numeric for conversion back to DateTime in my app?, or store as a Time?? not sure.