Hello,
How do I keep the value of 2.25 from oracle to SQL? This data type in oracle is Numeric(10,2) but when I retrieved it to SQL, the value changed to 2.00 instead.
The 2.25 is a value from a column called Material.
Thank you
Hello,
How do I keep the value of 2.25 from oracle to SQL? This data type in oracle is Numeric(10,2) but when I retrieved it to SQL, the value changed to 2.00 instead.
The 2.25 is a value from a column called Material.
Thank you
SELECT CONVERT(DECIMAL(10,2),Material)