title: Column is of type timestamp without time zone but expression is of type character varying : Nifi
body: <p>I am trying to insert CSV records to Postgres database using nifi.</p>
  
  <p>Sample csv file :</p>
  
  <pre><code>timenow,location
  '2019-10-21 15:13:11','colombo'
  </code></pre>
  
  <p>When nifi scenario runs, it gives following error</p>
  
  <blockquote>
    <p>Error column 'timenow' is of type timestamp without time zone but expression is of type character varying </p>
  </blockquote>
  
  <p>If I use normal <code>insert into conditions (timenow,location) values ('2019-10-21 15:13:11','colombo');</code></p>
  
  <p>No errors values inserted to table. Do I have to change nifi configurations to add this to table?</p>
  
  <p>I have changed Nifi CSVReader -> Timestamp format <code>YYYY-MM-DD HH:MM:SS</code></p>
  
  <p>EDIT: After first comment
  Nifi generated query is : <code>INSERT INTO public.conditions (timenow, location) VALUES ('2019-10-21 15:13:11','colombo')</code></p>
  
  <p>I have used this with timescaledb terminal and it inserted the record.</p>