Oracle returning different date entries (PSM Connect vs direct connect)

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Announcements

Welcome Idira to LIVEcommunity!

Our community just got stronger! Explore new identity security resources, connect with experts, and discover more ways to learn and collaborate.

Meet Idira

Oracle returning different date entries (PSM Connect vs direct connect)

L3 Networker

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.

5 REPLIES 5

L7 Applicator

Different timezones maybe? Does the Oracle client display the date&time based on the servers time or clients time?

L3 Networker

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?

L3 Networker

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.

L4 Transporter

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

L2 Linker

Hi @Prem Yadav​ 

 

I am facing the same issue. how do you fix it?

 

Thank you

  • 275 Views
  • 5 replies
  • 0 Likes
Like what you see?

Show your appreciation!

Click Like if a post is helpful to you or if you just want to show your support.

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!