We are connecting Oracle database. When querying the date from the ExecuteSQL processor, the date column timezone is getting changed to UTC. How can we avoid this ? Even I added oracle.jdbc.timezoneAsRegion=false in controller service properties, but still it did not work. We don't want to edit the bootstrap.conf for changing the timezone. Is there a way to change timezone in Nifi ?
Further if my date column value in DB is having 2021-06-20 01:00:00 , when read in nifi the value changes to 2021-06-19 19:30:00 where we can see 5:30 hours difference. Same thing if I run it through java code, I am getting an exact date value as in DB. Timezone in my system where Nifi is running is Time zone: Asia/Kolkata (IST, +0530)