SAP Knowledge Base Article - Preview

2638564 - Time is truncated from Datetime when reading from Excel workbook - Data Services

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.