Im trying to input these queries but I keep getting errors F

I`m trying to input these queries but I keep getting errors. For the first query it states that the bind variable \"MI\" is not declared while for the second query it states that for line 1 there`s an invalid number.

select MONTHS_BETWEEN(TO_DATE(12-25-2016 00:00:00\'),\'MM-DD-YYYY HH24:MI:SS\'),\'SYSDATE) from DUAL;

select TO_CHAR(\'21-JAN-13\',\'DD-MMM-YY\') from DUAL;

Solution

select MONTHS_BETWEEN(TO_DATE(\'12-25-2016\',\'MM-DD-YYYY\'),SYSDATE) from DUAL;

select TO_CHAR(\'21-JAN-13\',\'DD-MON-YY\') from DUAL;

I`m trying to input these queries but I keep getting errors. For the first query it states that the bind variable \

Get Help Now

Submit a Take Down Notice

Tutor
Tutor: Dr Jack
Most rated tutor on our site