When a run on the DB is not wrong, correct operation, but change a DB error; Error:
ORA - 01861: literal does not match the format string.
Could you tell me what's the problem? PB are not ripe, trouble
CodePudding user response:
Emergency, online etc.!!!!!!!!!!CodePudding user response:
CodePudding user response:
CodePudding user response:
Don't see the problem, the estimate is wrong somewhere elseCodePudding user response:
And PB it doesn't matter...A newspaper is the function to oracle wrong
CodePudding user response:
Or you use the string to compareCodePudding user response:
Two databasesCodePudding user response:
TO_DATE is a function of oracle, whether you in the second database,CodePudding user response:
The relationship with PB should be modest, the question on the ORACLE data, tracking the trans_dt value if there is a problem, it is recommended to use SQL Monitor to trackCodePudding user response:
2 a library data type structure is differentCodePudding user response:
Well, it seems that has nothing to do with PB, check the error database is there special Settings, don't support time format string as you can?CodePudding user response:
Startdate convert to string first,E.g. (string (startdate, 'yyyymmdd'))
CodePudding user response:
A newspaper is the function to oracle wrongCodePudding user response:
The building Lord, should transform the datetime PB into string comparison is as follows:String ls_startdate
Ls_startdate=string (startdate, 'YYYYMMDD HH: MM: SS)
Then change oralce statements to the following:
Trans_dt & gt;=TO_DATE (: ls_startdate, 'YYYYMMDD HH24: MI: SS')
Also must remember that the where clause to the database of expression on the left do not use a function or other operations, transfer function or operation to the right, to use as the index,
CodePudding user response:
In turn is next with the to_char ()