Another mistake often seen is when the user inserts a comma instead of a decimal point in a numerical expression, due to their proximity on the keyboard.
ORA-01722: invalid number Cause: The attempted conversion of a character string to a number failed because the character string was not a valid numeric literal.
It is an “invalid number” error, occurring during a failure when converting a character string to a valid number.
While this type of error can be an easy fix, it can be caused by a multitude of numerical mistakes.
As to TO_DATE(TO_CHAR( I read about it here (club-oracle.com/threads/convert-oracle-timestamp-to-date.692) to convert timestamp to datetime and have been using a variant of it.
Error starting at line : 1 in command - update AMU_POHEAD_T SET TGL_TIBA=trunc(sysdate) WHERE KD_STORE='1400' AND FAKTUR=: Factor and no_lpb is null Error report - SQL Error: ORA-01722: invalid number 01722.
If you are adding or subtracting from dates, make sure that you added/substracted a numeric value from the date.
Check that they contain only numbers, a sign, a decimal point, and the character "E" or "e" and retry the operation. While comparing different datatypes, we should first do explicit conversion. Reference: ORA-01722 exception occurs when we explicitly or simplicity try to convert a character string to a number. This may occur while inserting/updating in number field is SQL. 00000 - "invalid number" *Cause: *Action: create table AMU_POHEAD_T ( KD_STORE VARCHAR2(4 BYTE), FAKTUR VARCHAR2(15 BYTE), NO_LPB VARCHAR2(10 BYTE), TGL_TIBA DATE ); insert into AMU_POHEAD_T values ('1400', '000000000039746', null, sysdate - 30); insert into AMU_POHEAD_T values ('1400', 'A00000000039746', null, sysdate - 30); variable factor number; exec :factor := '000000000039746'; update AMU_POHEAD_T SET TGL_TIBA=trunc(sysdate) WHERE KD_STORE='1400' AND FAKTUR=: Factor and no_lpb is null; SQL Error: ORA-01722: invalid number @ Alex Poole, Thank you for the explanation and now I understand.The cause of the error is because I have a non-numeric character in my column(the FAKTUR column)?