DB2 DECIMAL有多大

答案:2 悬赏:60 手机版

解决时间 2021-03-09 22:10

提问者网友：捧腹剧
2021-03-09 01:20

DB2 DECIMAL有多大

最佳答案

五星知识达人网友：一秋
2021-03-09 01:37

https://www.ibm.com/support/knowledgecenter/SSPT3X_4.3.0/com.ibm.swg.im.infosphere.biginsights.commsql.doc/doc/r0000791.html
Datetime to Decimal

>>-+-DECIMAL-+-------------------------------------------------->
'-DEC-----'

>--(--datetime-expression--+-------------------------------+---><
'-,--precision--+----------+--)-'
'-,--scale-'

The schema is SYSIBM.

Numeric to Decimal

numeric-expression
An expression that returns a value of any built-in numeric data
type.
precision
An integer constant with a value in the range of 1 to 31.
The
default for precision depends
on the data type of numeric-expression:
31 for decimal floating-point
15 for floating-point and decimal
19 for big integer
11 for large integer
5 for small integer.

全部回答

1楼网友：猎心人
2021-03-09 02:40

numeric to decimal: >>-decimal--(--numeric-expression-------------------------------> >--+--------------------------------------------+--)----------->< '-,--precision-integer--+------------------+-' '-,--scale-integer-' character to decimal: >>-decimal--(--character-expression-----------------------------> >--+----------------------------------------------------------------------+--> '-,--precision-integer--+--------------------------------------------+-' '-,--scale-integer--+----------------------+-' '-,--decimal-character-' >--)----------------------------------------------------------->< datetime to decimal: >>-decimal--(--datetime-expression------------------------------> >--+--------------------------------------------+--)----------->< '-,--precision-integer--+------------------+-' '-,--scale-integer-'

我要举报

如以上问答信息为低俗、色情、不良、暴力、侵权、涉及违法等信息，可以点下面链接进行举报！