- Access exclusive content
- Connect with peers
- Share your expertise
- Find support resources
Our community just got stronger! Explore new identity security resources, connect with experts, and discover more ways to learn and collaborate.
04-24-2019 02:42 AM
I encountered an issue where the user connects to a Oracle Database via PSM Connect and performs a query, the date returned was 25-April-2019.
If he is using Secure Connect or manual direct access, the date is correct (24-April-2019). Anyone ever encountered such a weird interaction? The PAS system has the correct date and time configured.
04-24-2019 03:52 AM
Different timezones maybe? Does the Oracle client display the date&time based on the servers time or clients time?
04-24-2019 07:05 PM
Hmm I will get them to check again, but I think their previous example was they tried on the 20th and got 22nd as the example. They thought it was an internal bug so they waited and try again. The instant client lets you view the current time?
04-24-2019 08:17 PM
I gave a call and confirmed that they had the issue where there is a 2 day difference, beyond time zones.
If he runs it via the SQLDeveloper on PSM, the query returns the correct date. But if he runs it through PVWA > PSM > SQLDeveloper, it gives the wrong date. Might consider logging a case right here since it doesn't seem like a SQLDeveloper issue.
01-13-2020 05:52 PM
Hi Guys,
I have managed to fixed it and PSM-SQLDeveloper is working for me. Please let me know if you need any help.
Thanks
PY
03-06-2020 02:16 AM
Hi @Prem Yadav
I am facing the same issue. how do you fix it?
Thank you
Click Accept as Solution to acknowledge that the answer to your question has been provided.
The button appears next to the replies on topics you’ve started. The member who gave the solution and all future visitors to this topic will appreciate it!
These simple actions take just seconds of your time, but go a long way in showing appreciation for community members and the LIVEcommunity as a whole!
The LIVEcommunity thanks you for your participation!

