title: year and month in where clause in oracle 10g
body: <p>I have my date in format March 2014. How do I get month and year in number format to compare it in Oracle 10g query.</p>
  
  <pre><code>    &lt;?php
      $date = "March 2014";
      ?&gt;
  </code></pre>
  
  <p>My query that I am trying to get is</p>
  
  <pre><code>    select EMP_NAME where month = "03" and year = "2014".
  </code></pre>
  
  <p>Here is my table structure</p>
  
  <pre><code>    EMP_ID  |  EMP_NAME  |  C_DATE
         1    |     ABC    |  01-FEB-14
         2    |     XYZ    |  03-MAR-14 
  </code></pre>
  
  <p>Note: I am writing the coding in php</p>