SAP Knowledge Base Article - Preview

3577638 - SYSDATE shows different results between listener connection and non-listener connection

Symptom

SYSDATE shows different results between listener connection and non-listener connection.

SQL>SELECT TO_CHAR(SYSDATE,'YYYYMMDDHH24MISS') FROM DUAL; 

Or error like:

A *** ERROR => AppServerTimeSync, LargeTimeDiff DBTime - AppServerTime: AppServer time in internal format : 1740147454 AppServer in local time : 2025/02/21 14:17:34 GMT DBServer time in internal format : 1740167254 DBServer time in local time (db_time) : 20250221194734 


Read more...

Environment

SAP on Oracle

Product

SAP NetWeaver all versions

Keywords

SYSDATE, dual, time zone, TZ, ERROR => AppServerTimeSync, LargeTimeDiff DBTime - AppServerTime: AppServer time in internal format , SYSTIMESTAMP   , KBA , BC-DB-ORA , Oracle , How To

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.