Forum Discussion

mkjit256's avatar
mkjit256
Icon for Helper IV rankHelper IV
2 years ago

Copy Activity in Data Pipeline TimeZone defaulting to UTC

Hello Everyone,   i  did use the Copy Activity in a Data Pipeline to copy data from an on premise oracle db that has a timezone ("America/NewYork") to a Fabric lakehouse. In the source tab of the C...
Need Help
Pipeline
Show and Tell
mkjit256's avatar
mkjit256
Icon for Helper IV rankHelper IV
2 years ago

Hello jwinchell40 . the datetime in the source (oracle database) has no +TZ, it is under the format of: 2024-Apr-09 9:17:32 AM. 
What i am seeing is that the time component is getting changed. The datetime i am seeing in the lakehouse is: 2024-04-09 13:17:32.000000.

If it is just coming out as a datetime, can you convert it to the datetime + timezone in the soure query coming out of Oracle?

Can you explain more on how to do that. Thanks.

jwinchell40's avatar
jwinchell40
Icon for Resolver III rankResolver III
2 years ago

mkjit256 - Sorry for the delay.  Let me see if I can find the Oracle equivalent of:

 

SELECT <date> AT TIMEZONE 'EASTERN STANDARD TIME' AT TIMEZONE 'UTC' AT TIMEZONE 'EASTERN STANDARD TIME'  

I don't recall if I can go straight to EST when adding the TZ for the first time or if I have to Cast/Recast it accordingly.