Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a load statement to load a table from Oracle. The SQL Select statement is such as:
SQL SELECT *
FROM APPS."XETA_POS_V"
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?
You should use to_date function:
...Where FINAL_INVOICE_DATA > to_date('20051231', 'yyyymmdd')
- Ralf
You should use to_date function:
...Where FINAL_INVOICE_DATA > to_date('20051231', 'yyyymmdd')
- Ralf
Thank you!
Donna Lee
Oracle Applications Analyst
918-588-4761 Office
918-606-9891 Mobile
donna.lee@xeta.com<mailto:@paetec.com
Ralf,
This seems to work when I use the date_function, however, my list boxes lose their values when I utilize it. For example my Year, Month and Day list boxes do not have any values in them.