Oracle Database Discussions

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!

Oracle Issue: SYSDATE Does Not Match with OS System Time

De EncryptApr 17 2025

I am facing an issue where the SYSDATE in Oracle does not match the system time of the OS.

Here is the result from SQL Developer:
SELECT to_char(sysdate, 'dd/mm/yyyy hh24:mi:ss'), CURRENT_TIMESTAMP, DBTIMEZONE, SESSIONTIMEZONE FROM DUAL;
17/04/2025 04:55:19 17 APR 2025 11.55.19.014630000 ASIA/BANGKOK Asia/Bangkok Asia/Bangkok

host date:
Thu Apr 17 11:55:36 +07 2025

How can I resolve this issue?

Added on Apr 17 2025

#dba

2 comments

137 views