title: Cast-or-convert yyyy-mm-dd to dd-mon-yyyy am/pm
body: <p>I put up a question before on how to convert <code>07-DEC-18 01.00.54.984000 PM</code> to <code>2018-12-07 13.00.54.984000</code> and got a great answer in this  link: <a href="https://stackoverflow.com/questions/53682302/cast-or-convert-dd-mon-yyyy-am-pm-to-yyyy-mm-dd">Cast or convert DD-MON-YYYY AM/PM to YYYY-MM-DD</a></p>
  
  <pre><code>DECLARE @DateTimeString varchar(30) = '07-DEC-18 01.00.54.984000 PM';
  SELECT DATEADD(
        millisecond
      , DATEDIFF(millisecond, '', CAST(REPLACE(SUBSTRING(@DateTimeString, 11, 8), '.', ':') + RIGHT(@DateTimeString, 10) AS time))
      , CAST(LEFT(@DateTimeString, 9) AS datetime2)
      );
  </code></pre>
  
  <p>This question is now "closed/Approved" so I will put up a new question. </p>
  
  <p>I would like to make this <code>2018-12-07 13.00.54.984000</code> into <code>07-DEC-18 01.00.54.984000 PM</code>. Its the other way around from my first question. </p>