HOW CAN SELECT RECORDS BETWEEN THE SYSTEM DATE AND THE SYSTEM DATE - 7 DAYS. ITS BASICALLY THE EQUIVALENT OF DATEADD(). I CAN GET THE CURRENT DATE BY USING TO_DATE(SYSDATE, 'DD-MM-YYYY') BUT I CANT GET SYSDATE - 7 DAYS. THANKS....