The ORDERS table has a column ORDER DATE of data type DATE.
The default display format for a date is DD-MON-RR
Which two WHERE conditions demonstrate the correct usage of conversion functions?
A.WHERE order date TO DATE(ADD MONTHS(SYSDATE, 6),'MON DD YYYY')
B.WHERE TO CHAR(order date, 'MON DD YYYY')= 'JAN 20 2019'
C.WHERE order date > TO DATE(JUL 10 2018','NON DD YYYY')
D.WHERE order date TO CHAR(ADD MONTHS(SYSDATE, 6),'MON DD YYYY)
E.WHERE order date IN (To DATE('oct 21 2018','mon DD YYYY '), ro CHAR('Nov 21
2018', 'Mon DD YYYY'))
正确答案BC 