Instead of using 3 fields, you could store everything in 1 field using the lowest denomination of time that you will use, eg seconds. Then use a function to convert the value of `seconds` to days, minutes, hours.
On Dec 22, 3:20 pm, ron_m <[email protected]> wrote: > timediff is just 3 integers representing days, seconds, microseconds so you > could decompose it and store it as 3 int fields in the DB and then use the 3 > int values in a constructor to get it back. Alternative would be to convert > it to a float or double if you can accept rounding errors.
