I have a load statement to load a table from Oracle. The SQL Select statement is such as:
SQL SELECT *
Where FINAL_INVOICE_DATE > '20051231';
//Where "FINAL_INVOICE_DATE" Between'1-JAN-2010' and '2-JAN-2010';
//Where "FINAL_INVOICE_DATE" ='1-JAN-2010';
I cannot seem to limit my load to only the previous 2 years data. I am utilizing the FINAL_INVOICE_DATE field to check. However, somehow I keep getting 5 or 6 years worth of data. It is like it totally ignores my Where clause. What am I doing wrong?