Sample Header Ad - 728x90

Is the data type `numeric(p,s)` accurate?

2 votes
1 answer
94 views
I know that numeric is an "exact" data type, representing numbers as accurately as possible so that there are no floating-point errors such with float or real data types. But what about numeric(p,s)? It must approximate a number because of the fixed scale, but does it have floating-point inaccuracies or is it “safe”? I could not find any information about it. Maybe it is obvious, but I would like to understand this aspect better.
Asked by Sotis (328 rep)
Jan 17, 2025, 08:28 AM
Last activity: Jan 17, 2025, 06:57 PM