title: JSON-Data Date_Format doesnt show
body: <p>Hello and sorry my bad english :-)</p>
  
  <p>i have a little problem with my json data.</p>
  
  <p>I have a mysql database. in this database i have safed data in a date format.
  But the date format is in this format: YYYY.MM.DD.
  I need the Format DD.MM.YYYY.
  Well, i changed the request in this way:</p>
  
  <pre><code>$rs = mysql_query("SELECT event_name, DATE_FORMAT(beginn,'%d.%m.%Y'), DATE_FORMAT(ende,'%d.%m.%Y') FROM party WHERE ende &gt;= CURDATE()ORDER BY beginn ASC");
  </code></pre>
  
  <p>Now i get this string with the right date-format </p>
  
  <pre><code>{"sommer":[{"event_name":"testevent","DATE_FORMAT (beginn, '%d.%m.%Y')":"28.01.2015","DATE_FORMAT (ende, '%d.%m.%Y')":"30.01.2015"}]}
  </code></pre>
  
  <p>But now i have the problem, with my javascript.
  Before i did this with: DATE_Format (beginn,'%d.%m.%Y'), i got the date (but not in the right format).
  Now i got nothing.</p>
  
  <p>here my javascript:</p>
  
  <pre><code>var url="party.php";
  var activitydetail = sessionStorage.activitydetail;
  $.getJSON(url,function(json){
  
  $.each(json.sommer,function(i,item){
  
  $('&lt;li&gt;&lt;a href="#'+item.event_name+'"&gt; '+item.DATE_FORMAT (beginn, '%d.%m.%Y')+' - '+item.event_name+'&lt;/a&gt;&lt;/li&gt;').appendTo('#accor2');
  
          });
  
  
  
      });
  </code></pre>
  
  <p>The function doesn't work any more with <code>'+item.beginn+'</code> and doesn't work with <code>'+item.DATE_FORMAT(beginn, '%d.%m.%Y')+'</code></p>
  
  <p>Anybody knows a solution?</p>
  
  <p>A big thanks in advance :-)</p>