3 ms·
Times and time zones suck ... Floating-point arithmetic sucks ... Rounding errors suck ... Relational databases suck Guess what, any decent relational database
by ams6110 13y ago
Times and time zones suck ... Floating-point arithmetic sucks ... Rounding errors suck ... Relational databases suck
Guess what, any decent relational database will have a MONEY or at least a fixed precision DECIMAL type, as well as DATETIME and all the ancillary functions for computing intervals and adding and subtracting time. Half of your problems were because you weren't using a data store that properly represented your data.