title: Selecting full table when formatting date
body: <p>I am a complete beginner with SQL and I have been struggling with this for a while now and can't seem to come to the correct answer by myself. </p>
  
  <p>I am using the following code to display Date_t in the correct format </p>
  
  <pre><code>select date_format(Date_t, '%d/%m/%y at %k:%i') 
  as formatted_date 
  from tests
  ORDER BY id DESC
  </code></pre>
  
  <p>I can now display Date_t formatted as formatted_date but for the life of me cannot work out how to display the rest of my columns from tests. </p>
  
  <p>Apologies if this is a really stupid question. </p>