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
jwinchell40's avatar
jwinchell40
Icon for Resolver III rankResolver III
2 years ago

mkjit256 -  Is the data coming out of the server as datetime + TZ or just as a datetime?  Is the time component actually getting changed or is the TZ Offset just getting added to the end of the datetime? 

 

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?

 

Depending on the answers above, one thing you can do is just write the TZ conversion in the source/destination mapping of the Copy data.

 

Jeremy

  • mkjit256's avatar
    mkjit256
    Icon for Helper IV rankHelper IV
    1 year 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
      1 year 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.