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


      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.