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....
Results 1 to 3 of 3
Thread: Sysdate And To_date
|
Click Here to Expand Forum to Full Width |