Oracle TO_DATE function example:

delete   from BILLING_ITEM where period_end_date > TO_DATE('25-AUG-2018', 'DD-MON-YYYY') and requisitionid=7816182;