Best Data Type for time
Could you tell me the best Data Type to use to store time in a DB?
I need to store cumulative hours and minutes rather than an actual time - so I might need 255 hours and 35 minutes for example. I believe that the TIME data type only stores actual times of the day (e.g. 15:45).
Would I be better just to store the hours and minutes as separate fields with a varchar Data Type and just do some maths to get the exact end figure for display purposes as obviously the minutes field would be more than 60?
use an INTEGER column, and store minutes
Just store minutes... now why on EARTH didn't I think of that!!
thats why Rudy is 'Mr SQL' :D