sql - Error with selecting sysdate between time range -

i want fetch data sysdate-1 '00:00:00' between '23:59:59' time range. have tried, getting error.

this query..

select id_value, tn, line_type_id, account_type_id, port_id, current_status_id, error_code, error_desc, crm_app_code np_tn_dtls   join np_port_req_dtls b on a.np_txn_id=b.np_txn_id   left join np_subscriber_dtls c on a.np_txn_id=c.np_txn_id   left join np_subscriber_id_dtls d on d.subscriber_id=c.subscriber_id (b.request_start_time between sysdate-1 '00:00:00'       , sysdate '23:59:59') , (b.port_type_id != 2); 

please suggest me.

this expression wrong:

between sysdate-1 '00:00:00'   , sysdate '23:59:59' 

use trunc round date, can write this:

between trunc(sysdate-1) , trunc(sysdate) 

however, between up and including, prevent getting request happened @ midnight today, can better write this:

b.request_start_time >= trunc(sysdate-1) ,  b.request_start_time < trunc(sysdate)