2 Replies Latest reply: Jan 30, 2013 9:36 AM by JRQuinlan RSS

    substr equivalent in EQL

    User590184-Oracle
      Is there substr equivalent I can use in EQL.
      I need to extract month and date from a string attribute that is storing date as 'yyyymmdd'

      Also is there anything I can use in EQL that would be equivalent to add_months?

      Edited by: user590184 on Jan 29, 2013 4:06 PM
        • 1. Re: substr equivalent in EQL
          JaniceM
          I think this topic from the EQL guide refers to what you want:

          http://docs.oracle.com/cd/E29805_01/server.230/es_eql/toc.htm#Using%20EXTRACT%20to%20extract%20a%20portion%20of%20a%20dateTime%20value...

          Hope that helps,

          Janice
          • 2. Re: substr equivalent in EQL
            JRQuinlan
            The best practice in this situation would be to perform your date extractions within Clover ETL and ingest the data to the MDEX in the format you wish. If you haven't already, dowload the Data Integrator Designer pdf from Oracle and reference Ch 19 Metadata starting on page 109 then use the Clover date extraction functions to get what you need.