• few ways i can think of, which maybe of help or not:

    1. store all times against one specific date so it is a datetime but only ever one

    2. break minutes and seconds into 2 columns of type int or Small int

    3. store in a decimal so for 9:26 you'd store 0.00655093 this way could be prone to rounding errors though.

    My preference would be #1