2 Replies Latest reply: Feb 9, 2017 1:27 PM by Eduardo DImperio RSS

    Help with Timestamp

    Eduardo DImperio

      Hi everyone,

       

      I've problem with timestamp

       

      In this code below if i get only date() doesn't crash, but if i try to use with hh:mm:ss i get an error.

       

      someone could help me?

       

      DATA_ATUALIZACAO:

       

      LOAD

      Date(MAX(DATA_E_HORA),'DD/MM/YYYY hh:mm:ss') AS DATAMAX

      RESIDENT CARREGA_QVD;

       

      Let vDatamax=FieldValue('DATAMAX',1);

       

      NoConcatenate

      CARGA_INCREMENTAL:

      LOAD

      ID_SYSTEM,

      DATE_READ,

      ORA_ROWSCN,

      PORT,

      VALUE_READ,

      DATA_E_HORA,

      CONCENTRATOR

      WHERE DATA_E_HORA>$(vDatamax)

      ;

      SELECT

      id_system,

      port,

      date_read,

      value_read,

      concentrator,

      ora_rowscn,

      scn_to_timestamp(ora_rowscn) data_e_hora

      from rs_individual_read

      where   date_read between TO_DATE(SYSDATE) and TO_DATE(SYSDATE+1);

       

      Erro_timestamp.JPG