1 Reply Latest reply on Mar 10, 2020 9:25 PM by evamcdaz

    ORA-01830 in the database upgraded from 11g

    1776638
    1776638 Mar 10, 2020 8:44 PM

      Hello,

       

      I am migrating from 11g ...

       

      Apparently below construction works in 11g but does not in 12c or 19c:

       

      select TO_TIMESTAMP('2020-03-10 14:30:00.000000','YYYY-MM-DD HH24:MI:SS.FF3') from dual;

       

      In later releases it raises ORA-01830 error -"date format picture ends before converting entire input string"

       

      Is it supposed to work this way in 12c+?

      Are there any patches or session/system parameters to simulate 11g behavior?

       

      Please advise.

       

      Thanks,

      Andrew

        • 1. Re: ORA-01830 in the database upgraded from 11g
          evamcdaz
          evamcdaz Mar 10, 2020 9:25 PM (in response to 1776638)

          Hi Andrew,

          Please try either increasing your FF3 to FF6 or decreasing you fractional seconds to only .000.

          From

          select TO_TIMESTAMP('2020-03-10 14:30:00.000000','YYYY-MM-DD HH24:MI:SS.FF3') from dual;

          To

          select TO_TIMESTAMP('2020-03-10 14:30:00.000','YYYY-MM-DD HH24:MI:SS.FF3') from dual;

           

          This last statement will work in 12c.

           

          HTH,

          Eva