2 Replies Latest reply: Mar 26, 2014 9:22 AM by jgeidel RSS

    Timestamp bug still not fixed in 4.0.1.14

    jgeidel

      The bug when displaying timestamps is still not fixed in version 4.0.1.14.  I reported this bug on january 7th. The seconds of timestamps are sometimes not correct.

       

      Here is a little testing scenario:

       

      CREATE TABLE demo (a TIMESTAMP(6) );

      INSERT INTO demo a VALUES( TO_TIMESTAMP( '0187-01-31-15.03.16,309113', 'yyyy-mm-dd-hh24.mi.ss,ff6' ) );

      INSERT INTO demo a VALUES( TO_TIMESTAMP( '0187-01-31-15.03.17,309113', 'yyyy-mm-dd-hh24.mi.ss,ff6' ) );


      SELECT a, TO_CHAR( a, 'yyyy-mm-dd-hh24.mi.ss,ff6' ) FROM demo;

       

      My result is (of course depending on the NLS preferences:

       

      0187-01-31-15.03.17,3091130000187-01-31-15.03.18,309113
      0187-01-31-15.03.16,3091130000187-01-31-15.03.17,309113

       

      This bug does not occur in version 3 of SQL Developer. The result now differs from the result with version 4.0.0.13, but it is still not correct.

       

      Can someone please confirm this bug?

       

      Thanks,

      Jan