In Query Builder
- select a date column.
- Add an IN Clause as Constant and select a couple of date values from the dropdown.
- The query generated looks like this:
SELECT "TABLENAME".HIRE_DATE
FROM SCHEMA."TABLENAME"
WHERE "TABLENAME".HIRE_DATE IN (
('1/3/1990 12:00:00 AM'),('9/21/1989 12:00:00 AM'));
This results in error:
"Lookup Error - Oracle Database Error: ORA-01843: not a valid month"
Version 5.1.3 uses TO_DATE function and works correctly
