I am very new to SQL. IS there a suitable data-type for storing time values, specifically durations. What do I mean, well I am beginning a sports database. For sports, times as durations, laptimes, sectional times etc are captured and reviewed. Also lap comparisons eg faster and slower than previous or best times are recorded.
Does sql feature a data-type suitable for this need? Or would I need to use a data-type like decimal and then create a formula to convert the time to its lowest base for storage and the same back out.