What is the best column type of MySQL to store time limit?
I need to store timing like: 5:30 (5 minutes and 30 seconds) then i will use this time to count down for users but I'm not sure what kind of column is the best for such data?
Asked
Active
Viewed 663 times
1
mafortis
- 6,750
- 23
- 130
- 288
-
1Use the smallest unit(secs) and save it as an `Int` or `BigInt`. You can easily convert that back to hh:mm:ss after retrieval. – Udo E. Jan 09 '20 at 01:23
-
@UdoE. so you mean i save it as `330 (seconds)` then convert it to `mm:ss` in my view? – mafortis Jan 09 '20 at 01:26
-
@mafortis Yes, that's exactly what they mean. – ceejayoz Jan 09 '20 at 02:37