Hi. Dear Experts
I have an Scenario. JDBC (Oracle)- Proxy.
On Sender CC I have an SQL Sentence like.
Select Field1,Field2,Field3 from Tabla1 Where Date_F <= TO_DATE(sysdate,'yyyy/mm/dd') and Flag = 1
With the above sentence PI doesn't select any records. but I tested the same query on oracle client. and return 3 records.
Is there any problem with TO_DATE sentence?