KB39145: How to display datetime datatype data with millisecond precision in MicroStrategy for data stored in SQL Server

In Strategy, there is currently no formatting options available to display datetime format forms with millisecond values. If the precision is needed to be displayed on a report, a workaround is possible by casting the DATETIME data type to a VARCHAR data type.
  
The following procedure is an example of displaying the complete datetime data stored in a SQL Server database table. The data is stored in a format of "mm/dd/yyyy hh:mm:ss.mmm" with data type DATETIME.

•  Create a new attribute with the following form expression, where "Column1" is the name of the datetime column: 
  
  
  ApplySimple("CONVERT(VARCHAR(23), #0, 121)",[Column1] )
   

• This generates a SQL Server specific function to convert the DATETIME datatype into a VARCHAR with the following format: YYYY-MM-DD HH:MI:SS.MMM(24h).
  
•  In the Attribute Form editor, change "form format" to text:
  

• Save the attribute and update the schema 
  
• Place the created attribute on a blank report. This attribute ("text format") shows the complete datetime along with the milliseconds values (for comparison, another attribute "datetime format" was created using the same column and the default datetime format):