Symptom
- Date column value displayed incorrectly through remote table from Oracle Connection
- Column value in source is Date with format "yyyy-mm-dd", while preview the data from remote table in Datasphere shows 'yyyy.mm.dd 00:00:00'
- The same behavior for Virtual table created through Oracle remote source for SAP HANA Smart Data Integration(SDI)
- Column type is TIMESTAMP instead of Date in HANA virtual table
Read more...
Environment
- SAP Datasphere
- SAP HANA Smart Data Integration
Product
SAP Datasphere all versions ; SAP HANA smart data integration 2.0
Keywords
DS, dwc, oracle, format, date, timestamp , KBA , HAN-DP-SDI-DS , SAP Datasphere specific SDI issues , Problem
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.