Oracle Analytics Cloud and Server

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Why does extract day change the date?

Accepted answer
101
Views
14
Comments
2»

Answers

  • The system settings mentioned by Mostafa are in DV > Console > System Settings. Search for time zone and you find all the configs related to that.

    Before setting something there, you should be sure about your data, because that setting will change your OAC behavior when dealing with dates and times. And if you have OAC users from multiple time zones, they all will be affected by that parameter that is global for the whole OAC.

    If your data is correctly defined in your database, with a proper time zone define, there shouldn't be issues and setting the default time zone in OAC will do the job. If your data doesn't have a time zone in the database because there was an assumption of an implicit time zone, then setting the OAC default one will do the job without issues. Still, make sure about the quality of your data in the database, and if needed (multiple time zone involved in various sources in OAC), handle the time zone at the database level.

  • User_VMJII
    User_VMJII Rank 3 - Community Apprentice

    It looks like I don't have all the rights granted (I assume our IT does). But for now I'll stick with the existing solution (+h) so thanks for your help.

  • Karthick_
    Karthick_ Rank 3 - Community Apprentice

    Hi User_VMJII

    Could you save the data time as '2/8/2022 00:00Z'

    By adding Z at the end,

    Its more like an UTC. And it wont' change.

    Thanks

  • Hi Karthick

    Your question is different than the one posted in this thread, appreciate if you can start a new thread and provide details of the issue seen to better assist you.

    Thanks

    Gayathri