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
dbrowne's avatar
dbrowne
Microsoft Employee
2 years ago

Thanks for reporting this.  The product team has decided that this behavior is a bug, and Copy Data task should not be modifying datetime/datetime2 values.  This behavior will be changed in a future release of the On Prem Data Gateway.

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?