Enter Dollar Amounts Into Database |
Hi, When I insert lets say 50.00 into my database on the database it displays it like 50.0000
What is the best way to configure the column so if I put $50.00 it will stay that way or even if enter a value $1,000.00 Thank you. Second Image
There's only one rule - please don't tell anyone to go and read the manual. Sometimes the manual just SUCKS!
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
(10-06-2017, 01:31 AM)neuron Wrote: As u can see in your table structure, Thank you will try it out.
There's only one rule - please don't tell anyone to go and read the manual. Sometimes the manual just SUCKS!
(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 |
Welcome Guest, Not a member yet? Register Sign In |