The decimal data type is used to specify a numeric value.
小数数据类型用于指定一个数值。
Thee decimal data type is used to specify a numeric value.
小数数据类型用于指定一个数值。 。
For instance, the DECIMAL data type can be shortened to DEC or referred to as NUMERIC.
例如,DECIMAL数据类型可以缩短为DEC或表示为NUMERIC。
The price column is created as a DECIMAL data type with a precision of 5 and a scale of 2.
price列创建为DECIMAL数据类型,精度为5,刻度为2。
By default, the scale for a DECIMAL type is 0, which means the DECIMAL data type mimics an integer type.
默认情况下,decimal类型的刻度为0,这意味着DECIMAL数据类型模拟了整数类型。
The storage required for a DECIMAL data type is potentially much larger than it is for a normal floating-point data type.
DECIMAL数据类型需要的存储空间通常要比浮点数据类型大得多。
If you have no decimal data type available, an alternative is to work with integers, e. g. do money calculations entirely in cents.
如果你没有合适的小数数据类型可用,一个替代的方案是使用整数。比如,在计算钱数时把单位转化为分。
SQL-92 includes a decimal data type, which is an exact numeric type for representing fixed point decimal Numbers and performs basic arithmetic operation on decimal Numbers.
SQL- 92包括DECIMAL数据类型,它是用于表示定点小数的精确数字类型,它可以对小数进行基本的算术运算。
Some SQL dialects prefer to call this type NUMERIC, and others also include a MONEY data type, which is defined as a decimal number with two places to the right of the decimal.
一些SQL语言喜欢称此类型为NUMERIC类型,其它一些SQL语言则引入了MONEY数据类型,MONEY数据类型被定义为小数点右侧带有两位的小数。
If you've never encountered an exact precision data type, the distinction between a decimal and floating-point type may be confusing.
如果从未遇到过准确精度数据类型,那么对算术类型和浮点类型可能有些迷惑。
To create a decimal type, you specify the precision and, optionally, the scale for the data to be stored.
要创建算术类型,应当指定保存的数据的精度,并可选地指定数据的刻度。
In some cases, the MTK migrates a source DBMS data type to DECIMAL (x, 0).
在一些情况下,MT k会将一个源dbms数据类型迁移到DECIMAL (x,0)。
The scale of a numeric data type is the number of digits to the right of the decimal point.
数值数据类型的小数位数是小数点右侧的位数。
You should also use a Currency data type if you plan to perform many calculations on a field that contains Numbers with one to four decimal places.
若要对包含一到四位小数的数字的字段执行很多计算,也应该使用“货币”数据类型。
This is because TBCDField uses the currency data type that has a fixed scale of 4 decimal places.
BCD字段类型使用了货币类型,这种类型是小数点后是4位数。
This is because TBCDField uses the currency data type that has a fixed scale of 4 decimal places.
BCD字段类型使用了货币类型,这种类型是小数点后是4位数。
应用推荐