Subject | Decimal field precision question |
---|---|

Author | Jeff Dunlap |

Post date | 2007-09-27T17:21:25Z |

Dear FB Users:

I have installed the latest version of FB2 and created a Decimal field (3,3). Here is the applicable DDL:

INTEREST_RATE DECIMAL(3, 3)

I am trying to store values such as 2.575 or 95.555 percent for instance. What is confusing me is that these fields are allowing me to store much larger values such as:

1300000.532

The Interbase 6 PDF states that DECIMAL(precision, scale), where precision = 1 to 18 digits of precision to store and scale = 0 to 18 is the number of decimal places that can be stored.

I am confused because in my case, DECIMAL(3,3) stores a max of 3 decimal places but why does it allow me to store precision in the millionth place?

Please advise,

Jeff

---------------------------------

Be a better Heartthrob. Get better relationship answers from someone who knows.

Yahoo! Answers - Check it out.

[Non-text portions of this message have been removed]

I have installed the latest version of FB2 and created a Decimal field (3,3). Here is the applicable DDL:

INTEREST_RATE DECIMAL(3, 3)

I am trying to store values such as 2.575 or 95.555 percent for instance. What is confusing me is that these fields are allowing me to store much larger values such as:

1300000.532

The Interbase 6 PDF states that DECIMAL(precision, scale), where precision = 1 to 18 digits of precision to store and scale = 0 to 18 is the number of decimal places that can be stored.

I am confused because in my case, DECIMAL(3,3) stores a max of 3 decimal places but why does it allow me to store precision in the millionth place?

Please advise,

Jeff

---------------------------------

Be a better Heartthrob. Get better relationship answers from someone who knows.

Yahoo! Answers - Check it out.

[Non-text portions of this message have been removed]