I have a table from where I need to extract the order details. The requirement is such that the orders details should be older than todays date i.e less than current date and time less than 2200 HRS from the previous day.
But the problem is that whenever I use CREATE_TIME < '22.00.00' it removes all the orders between 22-23.59 for all the dates and not just previous day.
I am using the conditions as below:
AND CREATE_DTE < CURRENT_DATE
AND CREATE_TIME < '22.00.00'
Can anyone help me out in extracting all the details for orders created less than current date and time less than 2200 HRS from the previous day and not every day.