Get Started: AI Resources for Oracle Cloud HCM – Go Here
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
retrieving timestamp is not giving correct date and timestamp from Table PER_EXT_APP_IDENTIFIERS
Summary:
retrieving timestamp is not giving correct date and timestamp from Table per_ext_app_identifiers
Content (please ensure you mask any confidential information):
I am trying to build the report BI Publisher and noticed that DATE_FROM from Table PER_EXT_APP_IDENTIFIERS is not coming correctly , it looks like timezone value is not getting correctly.
Timestamp Stored in Table ---> 2023-06-24 6:00 PM
Oracle Bring —>Next day date ——> 2023-06-25 00:06:00
Version (include the version you are using, if applicable):
Code Snippet (add any code snippets that support your topic, if applicable):
SELECT
peai.person_id
,peai.assignment_id
Tagged:
0