<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>topic Oracle returning different date entries (PSM Connect vs direct connect) in PAM Self-Hosted Discussions</title>
    <link>https://live.paloaltonetworks.com/t5/pam-self-hosted-discussions/oracle-returning-different-date-entries-psm-connect-vs-direct/m-p/1298530#M2397</link>
    <description>&lt;P&gt;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.&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;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.&lt;/P&gt;</description>
    <pubDate>Wed, 24 Apr 2019 09:42:17 GMT</pubDate>
    <dc:creator>CyberArkAlumni</dc:creator>
    <dc:date>2019-04-24T09:42:17Z</dc:date>
    <item>
      <title>Oracle returning different date entries (PSM Connect vs direct connect)</title>
      <link>https://live.paloaltonetworks.com/t5/pam-self-hosted-discussions/oracle-returning-different-date-entries-psm-connect-vs-direct/m-p/1298530#M2397</link>
      <description>&lt;P&gt;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.&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;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.&lt;/P&gt;</description>
      <pubDate>Wed, 24 Apr 2019 09:42:17 GMT</pubDate>
      <guid>https://live.paloaltonetworks.com/t5/pam-self-hosted-discussions/oracle-returning-different-date-entries-psm-connect-vs-direct/m-p/1298530#M2397</guid>
      <dc:creator>CyberArkAlumni</dc:creator>
      <dc:date>2019-04-24T09:42:17Z</dc:date>
    </item>
    <item>
      <title>Re: Oracle returning different date entries (PSM Connect vs direct connect)</title>
      <link>https://live.paloaltonetworks.com/t5/pam-self-hosted-discussions/oracle-returning-different-date-entries-psm-connect-vs-direct/m-p/1298531#M2398</link>
      <description>&lt;P&gt;Different timezones maybe? Does the Oracle client display the date&amp;amp;time based on the servers time or clients time?&lt;/P&gt;</description>
      <pubDate>Wed, 24 Apr 2019 10:52:07 GMT</pubDate>
      <guid>https://live.paloaltonetworks.com/t5/pam-self-hosted-discussions/oracle-returning-different-date-entries-psm-connect-vs-direct/m-p/1298531#M2398</guid>
      <dc:creator>CyberArkAlumni</dc:creator>
      <dc:date>2019-04-24T10:52:07Z</dc:date>
    </item>
    <item>
      <title>Re: Oracle returning different date entries (PSM Connect vs direct connect)</title>
      <link>https://live.paloaltonetworks.com/t5/pam-self-hosted-discussions/oracle-returning-different-date-entries-psm-connect-vs-direct/m-p/1298532#M2399</link>
      <description>&lt;P&gt;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?&lt;/P&gt;</description>
      <pubDate>Thu, 25 Apr 2019 02:05:32 GMT</pubDate>
      <guid>https://live.paloaltonetworks.com/t5/pam-self-hosted-discussions/oracle-returning-different-date-entries-psm-connect-vs-direct/m-p/1298532#M2399</guid>
      <dc:creator>CyberArkAlumni</dc:creator>
      <dc:date>2019-04-25T02:05:32Z</dc:date>
    </item>
    <item>
      <title>Re: Oracle returning different date entries (PSM Connect vs direct connect)</title>
      <link>https://live.paloaltonetworks.com/t5/pam-self-hosted-discussions/oracle-returning-different-date-entries-psm-connect-vs-direct/m-p/1298533#M2400</link>
      <description>&lt;P&gt;I gave a call and confirmed that they had the issue where there is a 2 day difference, beyond time zones. &lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;If he runs it via the SQLDeveloper on PSM, the query returns the correct date. But if he runs it through PVWA &amp;gt; PSM &amp;gt; SQLDeveloper, it gives the wrong date. Might consider logging a case right here since it doesn't seem like a SQLDeveloper issue.&lt;/P&gt;</description>
      <pubDate>Thu, 25 Apr 2019 03:17:15 GMT</pubDate>
      <guid>https://live.paloaltonetworks.com/t5/pam-self-hosted-discussions/oracle-returning-different-date-entries-psm-connect-vs-direct/m-p/1298533#M2400</guid>
      <dc:creator>CyberArkAlumni</dc:creator>
      <dc:date>2019-04-25T03:17:15Z</dc:date>
    </item>
    <item>
      <title>Re: Oracle returning different date entries (PSM Connect vs direct connect)</title>
      <link>https://live.paloaltonetworks.com/t5/pam-self-hosted-discussions/oracle-returning-different-date-entries-psm-connect-vs-direct/m-p/1298534#M2401</link>
      <description>&lt;P&gt;Hi Guys,&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;I have managed to fixed it and PSM-SQLDeveloper is working for me. Please let me know if you need any help.&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Thanks&lt;/P&gt;&lt;P&gt;PY&lt;/P&gt;</description>
      <pubDate>Tue, 14 Jan 2020 01:52:50 GMT</pubDate>
      <guid>https://live.paloaltonetworks.com/t5/pam-self-hosted-discussions/oracle-returning-different-date-entries-psm-connect-vs-direct/m-p/1298534#M2401</guid>
      <dc:creator>P.Yadav785787</dc:creator>
      <dc:date>2020-01-14T01:52:50Z</dc:date>
    </item>
    <item>
      <title>Re: Oracle returning different date entries (PSM Connect vs direct connect)</title>
      <link>https://live.paloaltonetworks.com/t5/pam-self-hosted-discussions/oracle-returning-different-date-entries-psm-connect-vs-direct/m-p/1298535#M2402</link>
      <description>&lt;P&gt;Hi @Prem Yadav​&amp;nbsp;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;I am facing the same issue. how do you fix it?&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Thank you&lt;/P&gt;</description>
      <pubDate>Fri, 06 Mar 2020 10:16:20 GMT</pubDate>
      <guid>https://live.paloaltonetworks.com/t5/pam-self-hosted-discussions/oracle-returning-different-date-entries-psm-connect-vs-direct/m-p/1298535#M2402</guid>
      <dc:creator>carmen_mollica</dc:creator>
      <dc:date>2020-03-06T10:16:20Z</dc:date>
    </item>
  </channel>
</rss>

