3 Replies Latest reply on Feb 12, 2015 4:39 PM by rp0428

    Why timestamp before epoch displays with wrong seconds

    2883595

      Why

       

      select  TO_TIMESTAMP ('31.12.1969 23:59:59:01','dd.mm.yyyy hh24:mi:ss:ff2') "t" from dual ;

       

      returns

       

      31.12.1969 23:59:58,010000000

       

      Converting to char shows it correctly. Also time after epoch.

       

      select

      TO_TIMESTAMP ('1.1.1970 00:00:00:01','dd.mm.yyyy hh24:mi:ss:ff2') "t"

      from dual

       

      01.01.1970 00:00:00,010000000