title: How to convert/update dates from YYYY-MM-DD to DDMMMYYYY format?
body: <p>I'm relatively new to coding, but have started to pick it up at my new job. Currently I'm trying to get two columns in two different tables to have the same date format. The first is in <code>DDMMMYYYY</code> format (ie. 01Jan2019) while the second is in <code>YYYY-MM-DD</code> format (ie. <code>2019-01-01</code>). I would like to change 2nd to the 1st format, but I haven't seen any advice on the net for this. Any help would be greatly appreciated as the final goal is to join these two tables on this date column.</p>
  
  <p>I'm assuming the form of the code will look something like this?</p>
  
  <pre><code>update table2
  set date = ???????;
  </code></pre>