For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!
Hi
How to select between dates without trunc to avoid creating index on FINISH_DATE.
SELECT FINISH_DATE
FROM test
WHERE TRUNC(FINISH_DATE) BETWEEN TRUNC(ADD_MONTHS(SYSDATE,-3)) AND TRUNC(SYSDATE)
Regards,
eg