Is there a quick way of running a query to select records based on current sysdate - 1 ie yesterday.
Using Martin Gilbert's suggestion I get the current date & it works perfectly
CURDAT SUBSTR(CD, 1, 2) ||
SUBSTR(CD, 4, 2) ||
SUBSTR(CD, 7, 2)
Then use CURDAT in your selection
However I want to do the comparison to always include today & yesterdays data.
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!