title: Display date format as DD MM YYYY in active record Codeigniter
body: <p>How would I alter my active record to display my date as DD MM YYYY rather than YYYY MM DD?</p>
  
  <p><strong>Current Display</strong></p>
  
  <p><em>2016-01-07</em></p>
  
  <p><strong>Aim Display</strong></p>
  
  <p><em>07-01-2016</em></p>
  
  <p><strong>Current</strong>
  <strong>View</strong></p>
  
  <pre><code>&lt;?php echo $row-&gt;start_date; ?&gt;
  </code></pre>
  
  <p><strong>Tried</strong>
  <strong>View</strong></p>
  
  <pre><code>&lt;?php echo $row-&gt;DATE_FORMAT(start_date, '%d/%m/%Y'); ?&gt;
  </code></pre>
  
  <p><strong>Model</strong></p>
  
  <pre><code>class Profiles_model extends CI_Model
  
      {
  
          function get_bank()
          {
              $this-&gt;db-&gt;where('mem_id', $this-&gt;session-&gt;userdata("id"));
              $query = $this-&gt;db-&gt;get('bank');
              return $query-&gt;result();
          }
  
      }
  </code></pre>