Date BETWEEN another using CURRENT_DATE
Posted by:
Matt Snow
Date: November 24, 2014 03:14PM
Hello,
I'm needing to pull records that fall between today's date and the last week. I was using CURRENT_DATE with the BETWEEN filter...
"Assignment Status Dates"."Assignment Received Date" BETWEEN DATE_SUB(CURRENT_DATE(), - INTERVAL 7 DAY) AND CURRENT_DATE
Any assistance would be great!
Subject
Written By
Posted
Date BETWEEN another using CURRENT_DATE
November 24, 2014 03:14PM
November 24, 2014 09:46PM
November 24, 2014 11:10PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.