ORA-01862: the numeric value does not match the length of the format item

ORA-01862: the numeric value does not match the length of the format item
Cause: When the FX and FM format codes are specified for an input date, then the number of digits must be exactly the number specified by the format code. For example, 9 will not match the format specifier DD but 09 will.
Action: Correct the input date or turn off the FX or FM format specifier in the format string.

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 16:37

ORA-01862：数字值与格式项的长度不匹配,
.原因：当为输入日期指定FX和FM格式代码时，位数必须正好为格式代码指定的数字。例如，9将不匹配格式说明符DD，但09将。,
.操作：更正输入日期或关闭格式字符串中的FX或FM格式说明符。,
.

aiaiDBA

13718043309

010-86462881

ORA-01862: the numeric value does not match the length of the format item

1 个回答

相似问题