Skip to Content
0
Former Member
Dec 06, 2012 at 07:29 PM

Oracle Sentence - JDBC Sender - TO_Date

75 Views

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?

Regards.