3 Replies Latest reply on Jan 20, 2017 7:57 AM by Steven Hawkins

    teiid How to use BETWEEN keyword for TIMESTAMP in oracle database query

    Kulbhushan Chaskar Master

      Hi,

       

      I am trying to execute between keyword with timestamp but teiid throwing parsing exception.

       

      Query sample:

      SELECT SQL_REDO FROM "V$LOGMNR_CONTENTS" where SEG_OWNER=HARSHS and OPERATION IN("INSERT","UPDATE","DELETE") and TABLE_NAME=SOURCE_DM_DATA'' and TIMESTAMP BETWEEN TO_DATE ("2017-01-19T19:22:03", "YYYY-MM-DD"T"HH24:MI:SS") AND TO_DATE(2017-01-19T19:22:24, YYYY-MM-DD"T"HH24:MI:SS);

       

      Note : I am using teiid 8.13

       

      Thanks,

      Kulbhushan Chaskar.