7 Replies Latest reply: Sep 13, 2012 4:45 AM by Christian Bergeret RSS

    How to convert a type in where clause using SAP SQLConnector?

      Hello,

      I want to load some data from the LIKP table in SAP using the SAP SQLConnector. Furthermore I want to select the data for a specific period, but the date field in the table is not declared as a integer. If you look in the Oracle DBMS you will see, the field is declared as varchar.

      My Question:

      How can I convert the field in the WHERE clause that I can do a comparison to my selection criterion?

      Here an example (LFDAT still has to be converted in a way I don't know):

       


      LIKP:
      LOAD
      VBELN as delivery_number,
      LIFNR as supplier_number;
      SQL SELECT
      VBELN,
      LIFNR
      FROM LIKP
      WHERE LFDAT >= 20101013;


      Regards,
      Jonas