SAP Knowledge Base Article - Preview

1206395 - With SQL server, how do you hide the time section and only display the date from a timestamp in a List of Values (LOV)?


The List of Values (LOVs) displays the date in the following format:

dd/mm/yy HH:MM:SS.


You want to hide the time section so it only displays the date in a "dd/mm/yy" format.





  • SAP Business Objects XI 3.1 and above
  • SQL Server 2005 and above
  • SQL Server 2008 and above


SAP BusinessObjects Business Intelligence platform 5.1.8 ; SAP BusinessObjects Business Intelligence platform 5.1.9


9045 how hide time stamp date LOV List section , KBA , BI-RA , Reporting, analysis, and dashboards , 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.