title: Laravel how to change date format in the list
body: <p>We are retrieving the list from the database which is having date. We want to display it in different format. Suppose 10 Nov, 2014.</p>
  
  <p>Here is my Code</p>
  
  <p>Trail1:</p>
  
  <pre><code>$dropDown = Events::lists(DATE_FORMAT(event_date,'%d %M, %Y'), 'id');
  </code></pre>
  
  <p>Trail 2:</p>
  
  <pre><code>$dropDown = Events::lists("DATE_FORMAT(event_date, '%Y-%m-%d')  AS event_date", 'id')
  </code></pre>
  
  <p>But it throws error. Is there any way that we can use, to get desired date format in Laravel?</p>
  
  <p>Normal Query:</p>
  
  <pre><code>select id, DATE_FORMAT(event_date,'%d %M, %Y') AS event_date from events
  </code></pre>