title: How to insert DATE() in format DD/MM/YYYY
body: <p>I am using the below <code>INSERT</code> command however the format is '<strong><em>yyyy-mm-dd</em></strong>'. How would I change this to display as <strong><em>dd/mm/yyyy</em></strong>?</p>
  
  <p>Also, How would I display the week end (Last Day of week)? Sunday of every week, no matter what day it was run on?</p>
  
  <pre><code>insert into resource values ('APPUSER', date(),'Admin','0')
  </code></pre>