Has anyone solved the issue with the error code ORA-01830: date format picture ends before converting entire input string?
All I am trying to do is take a date input parameter and compare it to an end date.
FYI, I am using TOAD Data Studio 2025 R2 and I am connected to Oracle fusion ApplicationDB_HCM.
The following is the format that the dates are stored in the data base: 2025-11-14T00:00:00.000+00:00
The following is the input format that TOAD popup input window allows: 5/2/2025 1:00:00 AM
Here is the sql that I am trying to run that I am having an issue with.
SELECT * FROM PAYROLL_DETAIL
WHERE
to_date(:PPE,'yyyy-mm-dd hh24:mi:ss') > PAYROLL_DETAIL.END_DATE