title: Convert mysql query result into different date format
body: <p>I am using the following query to display a timestamp from a database:</p>
  
  <pre><code>    &lt;?php echo $testimonial-&gt;dated; ?&gt;
  </code></pre>
  
  <p>this query displays the timestamp as follows: yyyy-mm-dd hh:mm:ss</p>
  
  <p>I tried different date functions in order to display it in the format dd/mm/yyyy but did not have any luck with it, since I dont get how to correctly add this to the query mentioned above. Any idea on how to get this sorted? Thanks so much in advance :)</p>