title: convert date format while using date_add function in mysql
body: <p>I'm using the query below to add 14 days to a date</p>
  
  <pre><code>SELECT DATE_ADD(Paper_Sent_Dt,INTERVAL 14 DAY) as Rem_date from Referee_History;
  </code></pre>
  
  <p>the date format is yyyy/mm/dd but I require it in dd/mm/yyyy format.
  Is it possible to convert the date format while using the DATE_ADD function??</p>
  
  <p>as in, something like this</p>
  
  <pre><code>SELECT CONVERT(DATE_ADD(Paper_Sent_Dt,INTERVAL 14 DAY),%d-%m-%y) as Rem_date from Referee_History
  </code></pre>
  
  <p>if yes, please tell me how
  Thanks in advance</p>