ORA-01481: invalid number format model

ORA-01481: invalid number format model

Oracle PL/SQL error message: ORA-01481: invalid number format model.

Cause:

An invalid format parameter was used with the TO_CHAR or TO_NUMBER function.

Solution:

Correct the syntax, then retry the operation.

Example 1:

SELECT TO_NUMBER(SYSDATE,'HH24') FROM DUAL;

Output:

ORA-01481: invalid number format model




Correct:

SELECT TO_CHAR(SYSDATE,'HH24') FROM DUAL;

Output:

10

Oracle tutorial