Forum Discussion

mkjit256's avatar
mkjit256
Icon for Helper IV rankHelper IV
1 year 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
lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
1 year ago
an on premise oracle db that has a timezone ("America/NewYork")

That is rather unusual.  Servers and databases should by default run on UTC.

 

In your Select statement can you cast the dates to UTC?

  • mkjit256's avatar
    mkjit256
    Icon for Helper IV rankHelper IV
    1 year ago

    Thanks for your reply, am i getting the timezone wrong? i had got the America/NewYork fro running SELECT SESSIONTIMEZONE FROM DUAL. I am also getting a value of -04:00 When running: SELECT DBTIMEZONE FROM DUAL;

    Both commands are run from SQL oracle developer app. 

    The values that i am seeing in SQL oracle developer app are:
    2024-Apr-09 9:17:32 AM

    however in the lakehouse table what i am seeing is:

    2024-04-09 13:17:32.000000

     

    It is clear that the time in the lakehouse is 4 hours after the time in DB, which aligns with the -04:00 (America/New_York) answer i am getting.

     

    In my select statement that i am running to copy the table from source (oracle Db) to destination (lakehouse) is not casting dates to utc.