Requête sur les dates :

SELECT *
FROM CO.CUSTOMERS
INNER JOIN CO.ORDERS ON CUSTOMERS.CUSTOMER_ID = ORDERS.CUSTOMER_ID
WHERE (ORDER_STATUS = ‘COMPLETE’ OR ORDER_STATUS = ‘REFUNDED’)
AND ORDER_DATETIME >= to_date(’13-Sep-2018 00:00′, ‘DD-MON-YYYY hh24:mi’)