delete
from 
  STOCK
where 
  substr(LAST_DELIVERY_DATE,1, 4) || substr(LAST_DELIVERY_DATE,6,2)||substr(LAST_DELIVERY_DATE,9,2) 
  between '20230101' and '20230131'
and
  ACTUAL_AMT = 0  
;