5 Replies Latest reply: Jun 10, 2014 2:21 PM by J.A. RSS

    sysdate diff timestamp in RAC

    1931155

      Hi,

       

      i have an Oracle RAC, 11gr1, version 11.1.0.7.0, in HP superdome with HPUX 11.31.

       

      Since DST begin,  sysdate and current_timestamp show a different time:

       

      SELECT dbtimezone, SESSIONTIMEZONE, sysdate, CURRENT_TIMESTAMP FROM DUAL;

       

      shows

       

      DBTIMEZONESESSIONTIMEZONETO_CHAR(SYSDATE,'DD/MM/YYYYHH24:MI:SS')CURRENT_TIMESTAMP
      -06:00-05:0023/05/2014 13:33:4923/05/2014 02:33:49.342539 PM -05:00

       

      in node 1

       

      and

       

      DBTIMEZONESESSIONTIMEZONETO_CHAR(SYSDATE,'DD/MM/YYYYHH24:MI:SS')CURRENT_TIMESTAMP
      -06:00-05:0023/05/2014 14:33:4923/05/2014 02:33:49.342539 PM -05:00

       

      in node 2

       

      the problem is that a service depends on the time and date that the information is inserted with less than an hour apart is shown in the wrong order.

       

      somebody can help me?