Which two WHERE clause conditions demonstrate the correct usage of conversion functions?

Prev Question
Next Question

View the Exhibit and examine the description of the ORDERS table.

Exam 1Z0-047 - Which two WHERE clause conditions demonstrate the correct usage of conversion functions?

Which two WHERE clause conditions demonstrate the correct usage of conversion functions? (Choose two.)

A.
WHERE order_date > TO_DATE(‘JUL 10 2006′,’MON DD YYYY’) B. WHERE TO_CHAR(order_date,’MON DD YYYY’) = ‘JAN 20 2003’

B.
WHERE order_date > TO_CHAR(ADD_MONTHS(SYSDATE,6),’MON DD YYYY’)

C.
WHERE order_date IN ( TO_DATE(‘Oct 21 2003′,’Mon DD YYYY’), TO_CHAR(‘NOV 21 2003′,’Mon DD YYYY’) )

Prev Question
Next Question

Leave a Reply

Your email address will not be published. Required fields are marked *