When importing data into salesforce I'm seeing the datetime data appears to be handled as if it was GMT. In the scenario where I saw it this is the setup.
Using a service account to load into Salesforce with the Timezone set to America/El_Salvador in Salesforce.
The datetime field value in its original form is set to '2016-03-13 16:44:59.000'
After importing the data, viewing the value in Salesforce it is displayed to the user as '2016-03-13 10:44:59.000'
My question is, for the date time value to be correct do we need to either designate the timezone for the value or add/subtract the correct number of hours and minutes so the value is now GMT? Is there a way in Skyvia to set what timezone the data is configured as for the import so we don't need to perform this conversion? In DataLoader you can set the Timezone and it will respect this value when importing the data so that no conversions are needed.