SAP Knowledge Base Article - Preview

2324750 - Time(0) displays as Time data type on one computer, but as String data type on another, when reporting of MS SQL Server in Crystal Reports


  • Time(0) displays as string.
  • When modifying the SQL Query of a report, the data type of some field changes from Time to String.
  • When creating a report of MS SQL Server, and entering a SQL Query that cast data as time with Time(0), it displays as a string in Crystal Reports, instead of Time.



  • SAP Crystal Reports 2013
  • SAP Crystal Reports 2016
  • MS SQL Server 2012
  • MS SQL Server 2014
  • MS SQL Server 2016
  • MS SQL Server 2017


SAP Crystal Reports 2013 ; SAP Crystal Reports 2016


CR, Time(0) , KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , 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.