What timezone is used to load into Azure SQL DB

sam nick 286 Reputation points
2021-03-19T22:11:51.1+00:00

Hello,
I am using ADF to extract Salesforce data and load it into our Azure SQL DB. I always thought Azure uses/converts datetimes into UTC. My Salesforce profile is set to PST, but the Azure SQL db is in East region.

So data in Salesforce is createddate = 3/19/2021 15:00:00
The createddate when loaded into the DB = 3/19/2021 18:00:00

The getdate() on the Azure SQL db is 10 pm (UTC time when it is 6 pm EST)

So does ADF covert all times to the region of where the DB is or can we have it load all times as UTC?

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
10,127 questions
{count} votes