SYMPTOM
A report in Strategy 9.x does not display milliseconds present in a time field in the database.
STEPS TO REPRODUCE
Set up datetime field in SQL Server displaying milliseconds by running the following SQL scripts:
Sql
create table temp_test (col_1 datetime);
insert into temp_test values(getdate());
Run the following SQL script:
Sql
select * from temp_test;
SQL Server displays the time showing milliseconds as follows:
However when the select statement is run from Strategy DB Query Tool, the milliseconds are not displayed, as shown below:
When the table is imported into a Strategy project, an attribute mapped to it, and a report with the attribute in it is executed, the time is displayed as follows:
Formatting of values does not allow for milliseconds to be displayed.
CAUSE
This is a known issue in Strategy 9.x
ACTION
Strategy will continue to investigate and post updates as soon as they are available.
