Results 1 to 4 of 4
Thread: Best Data Type for time
Dec 10, 2009, 05:14 #1
- Join Date
- Feb 2006
- Bedford, UK
- 0 Post(s)
- 0 Thread(s)
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?