Fixed-Point types (exact value)-decimal, numeric
Decimal (M, d)
The decimal and numeric types store exact numeric data values.These types are used when it is important to preserve (SAVE) exact precision (precision), for example with
SQL Server field type decimal (18,6) before the decimal point is a few?Admittedly, this is a very low-level problem ....Why do you ask such a low-level question?Because of this problem, an SP failed to perform a data import .... That bothered me for
Original: SQL Server field type decimal (18,6) How many are before the decimal point? Remember the database SP bug handling onceSQL Server field type decimal (18,6) before the decimal point is a few?Admittedly, this is a very low-level problem
It is the result of Lua's computation. We can see that the computation result is very accurate. It is the calculation result of Python3. We can see that the calculation result is inaccurate: the decimal computation in JavaScript is also inaccurate.
There are non-standard data types such as float,double in MySQL, as well as standard data types such as decimal. The difference is that non-standard types, such as float,double, hold approximate values in db, while decimal saves values as strings.
03: octal decimal, 03 decimal03: octal decimal
View
Submit
Statistics
Question
Total time limit:
1000 ms
Memory limit:
65536kB
Description
All decimal places can be exactly represented. For example, 0.
Https://www.cnblogs.com/herbert/p/3402245.htmlBasisThe floating-point number is represented by the machine's double-precision (a-bit) of the floating-point number. provides approximately 17 bits of precision and ranges from 308 to 308 of the
Amazing decimal, maybe I will ask during the interview ~, Decimal interview
As busy as a dog during this time, blog writing will be delayed and we will continue to talk about it. Why is decimal magic? We all know that decimal is a primitive
Is the result of LUA calculation, you can see the result is very accurate.
Is the result of Python3 calculation, you can see that the calculation results are inaccurate:
The decimal calculation in JavaScript is not accurate, see this problem
Why are
See: http://blog.yemou.net/article/query/info/tytfjhfascvhzxcyt336A real number is one with a fractional part. However, they are not just for storing fractional parts, but they can also be usedDeclmal stores an integer larger than the bigint. MySQL
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.