Copy Activity in Data Pipeline TimeZone defaulting to UTC

Hello Everyone,

i am did use the Copy Activity in a Data Pipeline to copy data from an oracle db that has a timezone ("America/NewYork"). In the source tab of the Copy i had chosen a query as the Use Query option, where i am running select SQL statements with some cast of number data columns and creating some concatenated tables. What i am seeing after the copy is done, is that my date columns are having a time zone that looks to be UTC. How can i fix that?

0 comments