title: Trying To Solve remove the timestamp format conversion error by using "UpdateAttribute" processor i.e. ConvertJSONtoSQL-> UpdateAttribute--> PutSQL
body: <p><a href="https://stackoverflow.com/questions/45685703/nifi-putsql-timestamp-datetime-error-cannot-be-converted-error/45701012#45701012">From This Answer</a></p>
  
  <blockquote>
    <p>Same issue but no luck in my case i'm using ConvertJsonToSql---->(Relationship--SQL,Original)---->Update Attribute(Poperty from your answer)------>PutSql.  java.sql.SQLDataException :The value of the sql.args.28.value is Mon Oct 09 23:55:23 which cannot be converted to a timestamp.</p>
  </blockquote>
  
  <ol>
  <li>In Database date is storing in mysql datetime format 2017-09-11 14:26:13.</li>
  <li>NiFi flow file from Capture Change Mysql is showing like Mon Sep 11 19:56:13 IST 2017.</li>
  <li>JoltTransform Json also same and while converting form json to sql flow file attribute value of sql.args.27.type is 93 and sql.args.27.value is Mon Oct 09 23:38:55.</li>
  </ol>
  
  <p>any suggestions are welcome and appreciated.</p>