Forum Discussion

Element115's avatar
Element115
Memorable Member
2 years ago

QUESTION::PIPELINE::COPY DATA::MAPPING::DATETIMEOFFSET FORMAT

QUESTION: Does anyone know how to specify correctly the DateTimeOffset format of Copy data activity?   ISSUE: The data source is on EST time and the Copy data activity should load the data into a...
data engineering
Element115's avatar
Element115
Memorable Member
2 years ago

dbrowne I see... are you implying it is the OPGW that is doing the conversion and not the Copy data activity?

dbrowne's avatar
dbrowne
Microsoft Employee
2 years ago

The copy task is running on the gateway in this case.  When running in the cloud everything is in UTC time.

  • Element115's avatar
    Element115
    Memorable Member
    2 years ago

    Ok thanks. And what is this Mapping option for in the Copy data settings: DateTimeOffset format?

     

    Is it to tell the backend not to convert to UTC but instead use whatever timezone is specified in this setting string?