Symptom
- Data Services is truncating the time from a datetime when reading from Excel
- Some datetimes for the Excel spreadsheet are correctly imported as a Datetime datatype but others are imported as Varchar
- The time from a datetime is truncated
- Using a timestamp datatype does not help
Read more...
Environment
- SAP Data Services 4.2
- Excel workbook
Product
SAP Data Services 4.2
Keywords
excel, workbook, work book, bods, ds, truncate, time gets truncated, time is getting truncated , KBA , EIM-DS-EXE , Job Execution , 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.