Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

SYSDATE from Oracle DB different in PowerBI

Hi,   The following SQL gives different answers when imported into PowerBI compared to running in a local Oracle server.  Obvisouly I am pointing the PowerBI data source at the same local database ...
Need Help
  • v-yulgu-msft's avatar
    v-yulgu-msft
    8 years ago

    Hi Anonymous,

     

    Based on my research, in Oracle, you could use the NLS_TERRITORY parameter to set which day the week should start on. You can change it just for your session.

     

    Best regards,

    Yuliana Gu

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Thanks fo the reply v-yulgu-msft

 

When I run this in my Oracle server I get the following (for Thursday today):

 

 

 

 

Could it be a setting on my Oracle server end defaulting to Monday as start date for week?

 

Thanks,

Ben

v-yulgu-msft's avatar
v-yulgu-msft
Icon for Microsoft Employee rankMicrosoft Employee
8 years ago

Hi Anonymous,

 

Based on my research, in Oracle, you could use the NLS_TERRITORY parameter to set which day the week should start on. You can change it just for your session.

 

Best regards,

Yuliana Gu