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;
