Here is problem:
I was provided prices to 2 and 3 decimal places; we need to be only 2 decimal places.
Table called product
column called price - data type float - length 8 characters
e.g. of data
1. Is there a SQL query I could run on the price column to convert to 2 decimal places but round everything up? e.g. 0.224 would be 0.23
2. If not, is there a simple SQL query I could run on the price column to round all rows to 2 decimal places?
3. Is there a way of doing this without converting/changing the data type from float to numeric?
Thanks for the help in advance.