Question
Why are the date time fields different between Salesforce and my data warehouse?
Environment
Connector: Salesforce
Cause
Salesforce date times are always stored in the backend as Coordinated Universal Time (UTC). When displayed in your Salesforce client application, these values are then localized to your timezone. The Salesforce API (which we use to sync) relies on the backend. This is why records are written in UTC in your data warehouse.
Salesforce: Date and Time timezone during import using the SOAP API