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