I want to fetch the data for
sysdate-1 '00:00:00' between '23:59:59' time range. I have tried, but i am getting error.
This is my query..
select id_value, tn, LINE_TYPE_ID, ACCOUNT_TYPE_ID, PORT_ID, CURRENT_STATUS_ID, ERROR_CODE, ERROR_DESC, CRM_APP_CODE from np_tn_dtls a 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 where (b.REQUEST_START_TIME between sysdate-1 '00:00:00' AND sysdate '23:59:59') and (b.port_type_id != 2);
Please suggest me.