I would like to get some advice on storing time columns in MySQL.
We are developing a time sheet application that requires us to store checkin, checkout times, breaks in hours and minutes, but later carry out computations in decimal.
Should I use:
- time columns and use mysql time functions for the computations
- store the time as an integer (number of seconds since 1970 or number of hours) then show the hour/minute only for display purposes
Thanks in advance