Sql developer time is showing incorrect when checked with database time on server [message #669416] |
Sun, 22 April 2018 15:40 |
|
ashishuniyal
Messages: 7 Registered: April 2018
|
Junior Member |
|
|
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
22-APR-2018 15:36:37 sql developer connected to node2 connection string
Please help me on this.
Regards,
Ashish
|
|
|
|
|
|
|
|
|
|
|
|
|
|