title: PostgreSQL : cast string to date DD/MM/YYYY
body: <p>I'm trying to cast a <code>CHARACTER VARYING</code> column to a <code>DATE</code> but I need a date format like this : <code>DD/MM/YYYY</code>. I use the following <code>SQL</code> query :</p>
  
  <pre><code>ALTER TABLE test 
  ALTER COLUMN date TYPE DATE using to_date(date, 'DD/MM/YYYY');
  </code></pre>
  
  <p>The result is a date like this : <code>YYYY-MM-DD</code>.</p>
  
  <p>How can I get the <code>DD/MM/YYYY</code>format ?</p>
  
  <p>Thanks a lot in advance !</p>
  
  <p>Thomas</p>