OraFAQ Forum: Client Tools » Sql developer time is showing incorrect when checked with database time on server

Home » Other » Client Tools » Sql developer time is showing incorrect when checked with database time on server (DB version 11.2.0.4, OS- solaris)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

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

Report message to a moderator

Re: Sql developer time is showing incorrect when checked with database time on server [message #669417 is a reply to message #669416]

Sun, 22 April 2018 15:52

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

Welcome to this forum

Please read and follow the forum guidelines, to enable us to help you:
OraFAQ Forum Guide
How to use {code} tags and make your code easier to read

When was the last time the 2 nodes showed the same time?
What changed since then?

How can we reproduce what you report?

Report message to a moderator

Re: Sql developer time is showing incorrect when checked with database time on server [message #669419 is a reply to message #669417]

Sun, 22 April 2018 16:05

ashishuniyal
Messages: 7
Registered: April 2018

Junior Member

Hi,

this issue is occurring in non prod env and it was reported by the testing team. I apologize we are not aware of this, as when we asked testing team they were not sure when it was correct last time.

thanks

Report message to a moderator

Re: Sql developer time is showing incorrect when checked with database time on server [message #669420 is a reply to message #669419]

Sun, 22 April 2018 16:11

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>22-APR-2018 15:36:37 sql developer connected to node2 connection string
What is observed when sqlplus is used on node2?

What is OS name & version on both node1 & node2?

What is OS time on both node1 & node2?

Report message to a moderator

Re: Sql developer time is showing incorrect when checked with database time on server [message #669421 is a reply to message #669420]

Sun, 22 April 2018 16:23

ashishuniyal
Messages: 7
Registered: April 2018

Junior Member

when i ran the below query on sqlplus on both nodes its giveng the correct tome but when i run the same query on sql developer node2 connection string its givng the time 1hr before.

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

22-APR-2018 17:22:10 sqlplus time from node 1 and node2

22-APR-2018 16:22:18 -- node 2 sql devloper time

Report message to a moderator

Re: Sql developer time is showing incorrect when checked with database time on server [message #669422 is a reply to message #669421]

Sun, 22 April 2018 16:28

ashishuniyal
Messages: 7
Registered: April 2018

Junior Member

OS name on both nodes:
SunOS tresa760 5.10 Generic_150400-50 sun4v sparc sun4v

SunOS tresa761 5.10 Generic_150400-50 sun4v sparc sun4v

OS time on both nodes:
Sun Apr 22 16:28:33 CDT 2018
Sun Apr 22 16:28:35 CDT 2018

Report message to a moderator

Re: Sql developer time is showing incorrect when checked with database time on server [message #669423 is a reply to message #669421]

Sun, 22 April 2018 16:29

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

ashishuniyal wrote on Sun, 22 April 2018 14:23

when i ran the below query on sqlplus on both nodes its giveng the correct tome but when i run the same query on sql developer node2 connection string its givng the time 1hr before.

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

22-APR-2018 17:22:10 sqlplus time from node 1 and node2

22-APR-2018 16:22:18 -- node 2 sql devloper time

Do you get same incorrect results from multiple remote client using sqldeveloper?
IMO, the problem originates with the client & not the DB Server or database itself.

Report message to a moderator

Re: Sql developer time is showing incorrect when checked with database time on server [message #669424 is a reply to message #669423]

Sun, 22 April 2018 16:37

ashishuniyal
Messages: 7
Registered: April 2018

Junior Member

yes its occurring from multiple client sql developers.

Report message to a moderator

Re: Sql developer time is showing incorrect when checked with database time on server [message #669425 is a reply to message #669424]

Sun, 22 April 2018 16:49

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

At the present, I am out of ideas or possible explanations for what you report.
I'd like to say that what you report should not be possible, but since are reporting reality, I must be overlooking something.

Consider to post problem to URL below.

https://community.oracle.com/community/database/developer-tools/sql_developer

Report message to a moderator