title: Converting date filed from YYYY-MM-DD to DD-MON-YYYY
body: <p>I have checked the web looking for a solution, but haven't been able to get the error resolved.</p>
  
  <p>A couple of date fields in the source:</p>
  
  <blockquote>
    <p>EFFDT<br>
      END_DT<br>
      CREATE_DT<br>
      UPDATE_DT  </p>
  </blockquote>
  
  <p>Source data:  </p>
  
  <blockquote>
    <p>EFFDT  - dd-mon-yyyy<br>
      END_DT - dd-mm-yyyy<br>
      CREATE_DT - 11-Mrz-2009 08:20:26 AM , 22/10/1999 17:03:09<br>
      UPDATE_DT - 12-Aug-2000 11:33:16 AM  </p>
  </blockquote>
  
  <p>Target populating (without any transformation, straight move):</p>
  
  <blockquote>
    <p>EFFDT  - yyyy-mm-dd<br>
      END_DT - yyyy-mm-dd<br>
      CREATE_DT - 2009-03-11 08:20:26.000 , 2000-11-12 10:19:46.000<br>
      UPDATE_DT - 2000-08-12 11:33:16.000  </p>
  </blockquote>
  
  <p>Do I need the exact replica of the source data in target?</p>
  
  <p>I have tried using derived column to transform, but am not able to succeed.</p>
  
  <p>How can I achieve this?</p>