CODEWITHSUNDEEP
sqldb2
Reddy
Reddy

Reputation: 1

Remove zeros after two decimal places

I would like to remove zeros after two decimal places in DB2. I have more than 1000 rows for this column

For example

3.6900 needs to be converted to 3.69

I used cast in the query after my research and it gave me the correct result but I would like to understand what is DECIMAL(12,2) and how does this work ? Is there any better way to eliminate zeros?

SELECT  CAST(CG.RATE AS DECIMAL(12,2)) AS test from fd.OFFERS CG

Please let me know.

Upvotes: 0

Views: 1068

Answers (1)

bignose
bignose

Reputation: 32337

what is DECIMAL(12,2) and how does this work?

The DECIMAL data type represents numbers with a specified decimal precision. You can read a description of the numeric data types:

A DECIMAL number is a packed decimal number with an implicit decimal point. The position of the decimal point is determined by the precision and the scale of the number. The scale, which is the number of digits in the fractional part of the number, cannot be negative or greater than the precision. The maximum precision is 31 digits.

Upvotes: 1

Related Questions