The orders table has a column ORDER_DATE of data type date.

Oracle 1z0-082 Question Answer

The default display format for a date Is DD-MON-RR.

Which two where conditions demonstrate the correct usage of conversion functions?

WHERE order_date > TO_CHAR(ADD_MONTHS(SYSDATE, 6), 'MON DD YYYY')

WHERE TO_CHAR(order_date, 'MON DD YYYY') = 'JAN 20 2019'

WHERE order_date > TO_DATE

WHERE order_date IN (TO_DATE ('Oct 21 2018', 'Mon DD YYYY'), TC_CHAR('Nov 21 2018', 'Mon DD YYYY'))

WHERE order date > TO DATE('JUL 10 2018', *MON DD YYYY')

1z0-082 PDF/Engine

Get 65% Discount on All Products, Use Coupon: "ac4s65"