title: how to convert date column while loading using copy command in postgresql?
body: <p>I have an issue while loading the date column in PostgreSQL using copy command.
  actually, columns value, date </p>
  
  <pre><code>207     2017-03-08T01:25:34.000Z
  207     2017-03-23T09:33:03.000Z
  1266    2017-03-08T01:25:35.000Z
  1327    2017-03-08T01:25:35.000Z
  </code></pre>
  
  <p>I am unable to read date format like 2017-03-08 01:25:34 using timestamp.</p>
  
  <p>so I used varchar type to read date column. </p>
  
  <p>now I want to create one new column as date formatted and read date like  2017-03-08 01:25:34.</p>
  
  <p>my expected output is </p>
  
  <pre><code>207     2017-03-08T01:25:34.000Z    2017-03-08 01:25:34
  207     2017-03-23T09:33:03.000Z    2017-03-23 09:33:03
  1266    2017-03-08T01:25:35.000Z    2017-03-08 01:25:35
  1327    2017-03-08T01:25:35.000Z    2017-03-08 01:25:35
  </code></pre>
  
  <p>how to do it while loading using the copy command in PostgreSQL.</p>