select TransDate as date, sum(SubTotal + Shipping + Tax) as total from invoice group by TransDate;
1. Why doesn't Atrex us INT or DECIMAL to store financial data instead of FLOAT?2. Is the user expected to handle the rounding?3. What type of rounding is used when generating invoices and reports?
Also, if using the ROUND function with DOUBLE PRECISION or FLOAT values, it is possible to encounter rounding errors due to the nature of floating-point values and their inability to accurately express certain fractional real numbers.
Trouble logging in? Simply enter your email address OR username in order to reset your password.
For faster and more reliable delivery, add email@example.com to your trusted senders list in your email software.