All
I have the following code, and it was working perfectly, but now i get the following error
select DISTINCT(exchange) ,count(*) "Total Trades", MIN(totalroundtripsecs) as "Minimum RoundTrip Seconds", MAX(totalroundtripsecs) as "Maximum RoundTrip Seconds"
from fastfix_customer_perf where clientname = 'TEST1'
and ( exchangeaction != 'Cancel' or exchangeaction != 'Reject' )
and Action != 'Cancel' and Action != 'Reject'
and to_date(endate,'MM/DD/YYYY') between (select trunc(sysdate) -7 from dual) and (select to_date(trunc(sysdate)) from dual)
group by exchange
The error is
ORA-01847 day of the month must be between 1 and last day