Hi all and @BruceHarold ,
I am looking for some guidance on the best way to control for time zones when appending data to a feature class using Data Interoperability. In our case all times are negligible and so read in at 12:00 am, which roll back to the previous day when converted from Pacific Time to UTC when published to Portal.
I know it's not a Data Interop specific issue... my team has run into it with Model Builder as well. There are a few threads on this issue, such as this one and this one.
Example from data cache before publish to Portal:
Data published to Portal, in UTC:
So I then tried publishing the feature service first using ArcGIS Pro 2.9.2, and designating the Time Zone setting at time of publishing:
The initial publish is correct:
After running my Data Interop workbench to update the layer, the data appends in UTC:
I found this How To: article but it seems only apply to ArcGIS Online? We are currently on Enterprise 10.8.1.
Thank you in advance for discussion on this topic, and apologies if I've missed a very obvious transformer or part of the workflow.