Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

INVALID TIME CALCULATION

Arafat022May 30 2025

Hi,

when execute any of following statements or default Page item with any of them:

select to_char(systimestamp,'DD-MM-YYYY HH:MI:SS') from dual;

select to_char(sysdate,'DD-MM-YYYY HH:MI:SS') from dual;

the time came with minus 3 hourse about local current time

set the following code in Database Session

Comments
Post Details
Added on May 30 2025
1 comment
74 views