On Wednesday 10 August 2011 14:21:10 Daniel-Constantin Mierla wrote:
- a new column to store the seconds.milliseconds as double
Please don't use double, use a fixed point format. Double's are for scientific use, this is accounting so exact numbers are required.
In MySQL, one could use the DECIMAL type.