title: How to select MONTH() and YEAR() in codeigniter active record
body: <p>I am working in codeigniter, my problem is i want to select month &amp; year in below query.. it returns month but i need month &amp; year as a single value.. please help..</p>
  
  <pre><code>public function get_content(){
          $this-&gt;db-&gt;select('MONTH(newsroom_publish_date) as month');
          $this-&gt;db-&gt;from('content_table');
          $this-&gt;db-&gt;where('status', "Active");
          $query = $this-&gt;db-&gt;get();
          return $query-&gt;result();
      }
  </code></pre>