title: Checking if date falls in a specified month in Oracle
body: <pre><code>procedure Charge(p_inputdate   N VARCHAR2,//Date which accepts only MMYYYY format
                     inout_Cur OUT result_cur) IS
  </code></pre>
  
  <p>I need to validate the effective_date which is in date format (mm/dd/yyyy hh:mm:ss)</p>
  
  <p>For example: The user enters <code>112013</code> as input and the effective date to check is <code>11/12/2013 09:13:22</code></p>
  
  <p>Is  it possible to find whether the effective date falls within the specified month?</p>
  
  <p>can you please comment on this..</p>
  
  <blockquote>
    <blockquote>
      <blockquote>
        <p>I tried below way:</p>
      </blockquote>
      
      <p>V_INPUTDATE := to_char(TO_DATE(IN_INPUTDATE, 'MMYYYY','mmyyyy'));</p>
      
      <p>v_effectiveDate := substr(V_INPUTDATE,1,2)+'/'+'01'+'/'+substr(V_INPUTDATE,3,4);</p>
    </blockquote>
  </blockquote>
  
  <p>01 is nothing but month always start with 01(dd)
  Is this rightway ..??</p>