/support/notes/service/sap_logo.png){kind=logo}
SAP Knowledge Base Article - PreviewSymptom
You have a column of integer or number data type in a SQL Server database, which contains values such as 75.63,9.54,27.93 and 10.5. These numbers represent a number of days. You need to convert them into number of days, hours, minutes and seconds and show them in the reporter.
For example, 10.5 will be converted into 10 days, 12 hours, 00
minutes and 00 seconds.
Read more...
Product
SAP BusinessObjects Business Intelligence platform 6.5 ; SAP BusinessObjects Business Intelligence platform 6.5.3
Keywords
integer time,hours,minutes,seconds , 7885854 , KBA , BI-BIP , Business intelligence platform , 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.
/support/notes/service/facebook.svg)
/support/notes/service/twitter.svg)
/support/notes/service/youtube.svg)
/support/notes/service/linkedin.svg)
/support/notes/service/instagram2.svg)