Forum Discussion

Element115's avatar
Element115
Icon for Memorable Member rankMemorable 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
Icon for Microsoft Employee rankMicrosoft 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
Icon for Memorable Member rankMemorable 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?