Convert datetime to date in Framework Manager

Technote (troubleshooting)


Problem(Abstract)

How to convert a Datetime to Date data type in Framework Manager?

How to remove the Time portion of the Datetime field in Framework Manager?

Solution 1: Cast the Datetime field to a String and take a substring of the date portion. Then cast to a date. For example: cast (substring ( cast([ORCLGOSL].[ORDERHEADER].[ORDERDATE] , varchar(50)), 1, 10),date) Solution 2:

Create a calculation and cast the Datetime field to a Date.

For example:

cast([ORCLGOSL].[ORDERHEADER].[ORDERDATE], date)

Related information

Framework Manager User Guide

Cross Reference information
Segment Product Component Platform Version Edition
Business Analytics Cognos 8 Business Intelligence Cognos Connection
Business Analytics Cognos 8 Business Intelligence Framework Manager
Business Analytics Cognos 8 Business Intelligence Report Studio
Business Analytics Cognos ReportNet ReportNet

Historical Number

1023407

Rate this page:

(0 users)Average rating

Document information


More support for:

Cognos ReportNet
ReportNet

Software version:

Cognos 8 BI Cognos Connection 8.2, Cognos 8 BI Framework Manager 8.1, Cognos 8 BI Framework Manager 8.2, Cognos 8 BI Report Studio 8.1, Cognos 8 BI Report Studio 8.2, Cognos ReportNet 1.1MR3, Cognos ReportNet 1.1MR4

Operating system(s):

Win32, Windows

Reference #:

1367684

Modified date:

2007-12-11

Translate my page

Machine Translation

Content navigation