Regarding 'sysdate' !

Sysdate with Time interval :

SELECT to_char(entry_date -8/24, 'DD-MON-YYYY HH12:MI:SSam'), OLD_BIN_ID old_bin, NEW_BIN_ID NEW_BIN, ISBN ASIN, QUANTITY 
FROM BINEDIT_ENTRIES
WHERE ENTRY_DATE BETWEEN trunc(SYSDATE) -1 +4/24 AND trunc(SYSDATE) -1 +16/24
--where entry_date BETWEEN trunc(sysdate)-1 '00:00:00' AND trunc(sysdate)-1 '00:00:00.000'
AND substr(old_bin_id,1,2) = 'SC'
AND substr(new_bin_id,1,2) = 'vt'
GROUP BY ENTRY_DATE, OLD_BIN_ID, NEW_BIN_ID, ISBN, Quantity
ORDER BY QUANTITY DESC;

Example :

select a.br_code,b.branch_nm,a.err_dt,a.err_code,a.err_msg from error_log a , BRANCH_HOME_BANK b where a.err_dt --like 'sysdate-1'
BETWEEN trunc(SYSDATE) -2 +20/24 AND trunc(SYSDATE) -2 +24/24
--BETWEEN TO_DATE('12/02/2014 20:00:00', 'MM/DD/YYYY HH24:MI:SS') AND TO_DATE('12/02/2014 23:59:00', 'MM/DD/YYYY HH24:MI:SS')
AND ERR_CODE like '%-20000%'  and br_code not in ('0100','0116','0117','0500')
order by a.err_dt desc  

Here , 20/24 means 8 PM

Sysdate : Todays date

sysdate -1 : 1 Day before 

select br_code,err_dt,err_code,err_msg from error_log  where err_dt --like 'sysdate-1'
BETWEEN trunc (SYSDATE) +20/24 AND trunc(SYSDATE)  +24/24
--BETWEEN TO_DATE('12/02/2014 20:00:00', 'MM/DD/YYYY HH24:MI:SS') AND TO_DATE('12/02/2014 23:59:00', 'MM/DD/YYYY HH24:MI:SS')
AND ERR_CODE like '%-20000%'  and br_code not in ('0100','0116','0117','0500')
order by err_dt;