Enter Dollar Amounts Into Database |
(10-06-2017, 01:40 AM)wolfgang1983 Wrote:(10-06-2017, 01:31 AM)neuron Wrote: As u can see in your table structure, You may want to keep the 4 decimal points precision. Options are discussed in this stackoverflow question and others. https://stackoverflow.com/questions/2244...-and-scale You can always display or retrieve the values at two decimal points. For example Code: SELECT ROUND(gross_amount, 2) AS gross_amount |
Messages In This Thread |
Enter Dollar Amounts Into Database - by wolfgang1983 - 10-06-2017, 01:10 AM
RE: Enter Dollar Amounts Into Database - by neuron - 10-06-2017, 01:31 AM
RE: Enter Dollar Amounts Into Database - by wolfgang1983 - 10-06-2017, 01:40 AM
RE: Enter Dollar Amounts Into Database - by Shawn - 10-08-2017, 08:03 PM
|