title: String to Date PostgreSQL
body: <p>I have table name bill_date 
  and this is my table row, the field type of create_date is character varying</p>
  
  <pre><code>id | create_date 
  1  | 20080108
  2  | 20080116
  </code></pre>
  
  <p>I want to convert create_date to Date but when I used this QUERY</p>
  
  <pre><code>SELECT to_date(create_date, 'YYYYddmm'),* FROM bill_date 
  </code></pre>
  
  <p>I got wrong result</p>
  
  <pre><code>2008-08-01
  2009-04-03
  </code></pre>
  
  <p>there something wrong in field type? any help. thanks</p>