1 Reply Latest reply on Apr 23, 2018 2:46 PM by rp0428

    Sql developer time is showing incorrect when checked with database time on server

    3695104

      Hi All,

       

      I am facing an issue in our environment, we have 2 node rac environment and when i am running the below query in server with sqlplus its showing the below time and the same query if i ran from 2node of the rac its giving the different output and when i am running from node1 its giving the correct time as sqlplus.

       

       

      select to_char(sysdate,'DD-MON-YYYY HH24:MI:SS') "DATE" from dual;

       

      22-APR-2018 16:35:22 sqlplus on both the servers and sql devloper node1 connection string

       

      22-APR-2018 15:36:37 sql developer connected to node2 connection string

       

      Please help me on this.

       

      Regards,

      Ashish