In running the following I receive no rows selected but if I take the where clause off I receive a row.
In the tool called sql developer , I run the same sql statement the where clause works.
Why? Is it because the trunc function is not valid?
sqlplus -s 1234/1234<<END
spool farmerList.csv replace
select service_date, open_qty, closed_qty, cancelled_qty, open_closed_canc_qty
from dashboard_servticket_dispstats where trunc(service_date) = trunc(sysdate -1);