0 Replies Latest reply on Jun 18, 2020 7:19 AM by 3467535

    Why sysdate from dual not showing current date and time

    3467535

      Hi All,

      i had experience on two of our UAT environment when we select sysdate from dual, it not showing the current date and time as per db server.

      Date in the linux server is correct but sysdate not showing correct date. Then, i had run this script to fixed it - alter system set fixed_date = none;

       

      Is there any reason why the sysdate from dual not same as per db server date?

       

       

      Thanks,

       

      Izzati