user had different system date extracted compared with oracle [message #671503] |
Sun, 02 September 2018 22:41 |
reym21
Messages: 241 Registered: February 2010 Location: Philippines
|
Senior Member |
|
|
Gurus,
Good day!
This is the first time we encountered a user when logged in at SQLplus
had different timestamp extracted compared to Oracle user who had it correctly.
In the attached screenshot, once ORACLE user logged in, it can select the correct
sysdate/timestamp, but when said user logged-in, it can select the correct sysdate
but a delayed (of 6 hours) timestamp. The logins were done both at the same server.
The server were once administered by our contractors and was later turned-over to us.
We haven't changed any configurations to said dB server since we started managing this.
What's causing this? Thank you in advance.
|
|
|