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 ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.