SELECT STATEMENT TO RETRIEVE RECORDS FOR 3 YEARS
I am writting a select statement to retrieve information from PO_Vendors Table
where the vendors are Trade.
I need this information for the last 3 years and this is the way I am writting
my statement but it's not giving me anything. Where I am going wrong?
select * from PO_vendors
where PAY_GROUP_LOOKUP_CODE ='TRADE'
and SYSDATE BETWEEN TO_DATE('01/01/99 00:00:00','mm/dd/yy hh24:mi:ss') AND
TO_DATE('12/31/00 23:59:59','mm/dd/yy hh24:mi:ss');
Please Help
Lilee