SQLTeam.com | Weblogs | Forums

Oracle to SQL


#1

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


#2

SELECT CONVERT(DECIMAL(10,2),Material)