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....
Printable View
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....
select *
from tablename
where date_field > sysdate- 7
and date_field < sysdate;
SysDate is a date already, by the way. Don't convert it to a character string.Quote:
Originally posted by bigpomp81
... TO_DATE(SYSDATE, 'DD-MM-YYYY') ...