Welcome Guest, Not a member yet? Register   Sign In
Enter Dollar Amounts Into Database
#2

As u can see in your table structure, 
the column types of cash_total_value and gift_card_value are type of DECIMAL(15,4) this means this columns can have total of 15 digits and 4 out of 15 will be fraction part.

In order to get 2 digits after "." you need to change type of columns to DECIMAL(15,2).

1,000.00 like numbers need to be converted to 1000.00 before you insert to database
Reply


Messages In This Thread
RE: Enter Dollar Amounts Into Database - by neuron - 10-06-2017, 01:31 AM
RE: Enter Dollar Amounts Into Database - by Shawn - 10-08-2017, 08:03 PM



Theme © iAndrew 2016 - Forum software by © MyBB