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? (Choose two.)
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? (Choose two.)
The correct usage of conversion functions can be seen in the following conditions: 1. Where order_date > TO_DATE('JUL 10 2018', 'MON DD YYYY'): This condition correctly uses TO_DATE to convert a string into a date format for comparison with order_date. 2. Where TO_CHAR(order_date, 'MON DD YYYY') = 'JAN 20 2019': Assuming the syntax error where '.' is replaced by ',' is corrected, this condition correctly uses TO_CHAR to convert the order_date to a string to perform the comparison. Options that contain incorrect or non-existent functions like ADD_MONTH() or use functions incorrectly for the context are not valid.
checked
A & D is correct. below works select * from emp WHERE hire_date > To_Char(ADD_MONTHS(SYSDATE, 6), 'dd mm yyyy');
E is wrong. the string in quotes seems like a date after = but DB will only consider it as a string, not a date.
I thin AE is correct
AE correct
Only A works. Assuming that in E there is a mistake and should be "," instead of ".", the E should be correct answer.
also in B the function ADD_MONTH is wrong it must be ADD_MONTHS