https://community.cloudera.com/t5/Support-Questions/Apache-NiFi-Execute-SQL-processor-bug/m-p/293765#M216862 <P>I've found a solution, but I think it's not a better way to deal with this.</P><P>I've added an option near date type column in sql query (for pgsql) like:</P><P><BR /><FONT face="book antiqua,palatino,serif" size="4" color="#000080"><EM>select deal_date at time zone 'UTC-6' as&nbsp;deal_date&nbsp;</EM></FONT></P><P><FONT face="book antiqua,palatino,serif" size="4" color="#000080"><EM>from schema_name.table_name</EM></FONT></P><P>&nbsp;</P><P>Why UTC-6 - for equality with 00h00m00s of my country (I've found this by empiric way) then I put this timestamp data to pgtable in column with date data type and that's was fine.&nbsp;</P><P>&nbsp;</P><P>If you have the best way to deal with this issue just let me know</P> Sat, 11 Apr 2020 22:34:48 GMT acoast83 2020-04-11T22:34:48Z