Converting the Timestamp to a Date

In the IBM® Cognos® Framework Manager model, define a calculation that uses the cast function to convert the timestamp to a date. For example, the following expression converts the data type of the column COL1 to date:

cast ([SCOTT_TIGER].[DATES].[COL1],DATE)

If you create a parameter in IBM Cognos Analytics - Reporting that filters on this calculation, the default prompt presents a date control.