title: How to convert format "yyyy-MM-dd HH:mm:ss in logstash
body: <p>I fetch the data through Oracle, and the database has a field updated_at in the format &quot;<em>yyyy-MM-dd HH:mm:ss</em>&quot;.
  However, it has been automatically changed to ISO8601 format in logstash.
  So I try to change the format &quot;<em>yyyy-MM-dd HH:mm:ss</em>&quot;, but I get an error like _dateparsefailure.
  Here is my config file.
  What is the problem?</p>
  <pre><code>input {
     jdbc {
          jdbc_validate_connection =&gt; true
          jdbc_driver_library =&gt; &quot;/usr/share/logstash/logstash-core/lib/jars/ojdbc8.jar&quot;
          jdbc_driver_class =&gt; &quot;Java::oracle.jdbc.OracleDriver&quot;
          jdbc_connection_string =&gt; &lt;connection string&gt;
          jdbc_user =&gt; &lt;my username&gt;
          jdbc_password =&gt; &lt;my password&gt;
          use_column_value =&gt; true
          statement =&gt; &quot;SELECT * FROM IP_INFO&quot;
          schedule =&gt; &quot;*/1 * * * *&quot;
          charset =&gt; &quot;UTF-8&quot;
          enable_metric =&gt; false
     }
  
  }
  
  filter {
      date {
          match =&gt; [
              &quot;updated_at&quot;, &quot;yyyy-MM-dd HH:mm:ss&quot;
          ]
          target =&gt; &quot;updated_at&quot;
      }
  }
  
  output {
    stdout {
      codec =&gt; rubydebug
    }
  }
  
  
  </code></pre>
  <p><strong>Result</strong></p>
  <pre><code>{
      &quot;@timestamp&quot; =&gt; 2020-10-14T07:34:03.755Z,
      &quot;updated_at&quot; =&gt; 2020-10-14T04:44:37.000Z,
      &quot;tags&quot; =&gt; [
          [0] &quot;_dateparsefailure&quot;
      ],
      &quot;created_at&quot; =&gt; 2020-09-29T15:56:37.000Z
  }
  
  </code></pre>
  <p>So, I just convert updated_at and created_at field to &quot;<em>yyyy-MM-dd HH:mm:ss</em>&quot;.
  Can you help me?</p>