Oracle "DATE" datatypes that are replicated to HANA "timestamp" datatypes are not showing the correct time in HANA. In the replication definition the "DATE" column is defined as an "rs_oracle_datetime" datatype.
For example: From Oracle when "May 5, 2014 10:34:12" is replicated to HANA, the datetime value changed to "May 5, 2014 12:00:00".
- SAP Replication Server RS 15.7.1 SP100 and UP
- SAP Replication Server Option for Oracle 15.7 and UP
HANA timestamp, Oracle date, ExpressConnect for SAP HANA Database(ech) , KBA , BC-SYB-REP-RSO , Rep Server Options (RSO) , Problem
About this pageThis 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.