View the Exhibit and examine the description of the ORDERS table. Which two WHERE
clause conditions demonstrate the correct usage of conversion functions? (Choose two.)
A.
WHERE order_date IN (TO_DATE(‘Oct 21 2003’,’Mon DD YYYY”), TO_CHAR(‘NOV 21
2003′,’Mon DD YYYY”))
B.
WHERE order_date > TO_CHAR(ADD_MONTHS(SYSDATE,6),’MON DD YYYY”)
C.
WHERE order_date > TO_DATE(‘JUL 10 2006’,’MON DD YYYY)
D.
WHERE TO_CHAR(order_date,’MON DD YYYY) = ‘JAN 20 2003’