Hi,

I'd like to cast a column of datatype " IntervalDayTimeValue" ([fällig seit]) to integer (smallint). So I did the following:
​
As you can see, the Syntax Editor does not throw any error.
But when I want to run the Report, the following error appears:


If I do something like cast(1,0; smallint) --> everything is fine

Furthermore, I tried the other way round: cast (0; intervalday) (I want to cast the Zero into Interval-datatype that I can compare them)
--> in this case, I'm not sure about the Syntax because the explanation for the function says that you have to add the type of Interval - but how ? I tried: interval_day,  intervalday etc. but nothing works.

I'd be glad if anyone can help.

Thanks in advance,
Tina




------------------------------
Tina
------------------------------

#CognosAnalyticswithWatson

Hi Tina,
The following is a screen shot from FM, but RS has the same functionality.



In the example : to get a zero value interval day to second, you specify:
0 00:00:00.000000000 day to second

That will give a literal value that you can compare to columns of the same datatype.
// Henk


------------------------------
HENK CAZEMIER
------------------------------

Original Message:
Sent: 03-15-2019 12:03 PM
From: Tina Noack
Subject: cast (...)

Hi,

I'd like to cast a column of datatype " IntervalDayTimeValue" ([fällig seit]) to integer (smallint). So I did the following:
​
As you can see, the Syntax Editor does not throw any error.
But when I want to run the Report, the following error appears:


If I do something like cast(1,0; smallint) --> everything is fine

Furthermore, I tried the other way round: cast (0; intervalday) (I want to cast the Zero into Interval-datatype that I can compare them)
--> in this case, I'm not sure about the Syntax because the explanation for the function says that you have to add the type of Interval - but how ? I tried: interval_day,  intervalday etc. but nothing works.

I'd be glad if anyone can help.

Thanks in advance,
Tina




------------------------------
Tina
------------------------------

#CognosAnalyticswithWatson

Hi Henk,

thank you very much for the quick reply. 

I tried your proposal but unfortunately, it didn't work :-/ I guess it was because of the Dataelement I wanted to cast [fällig seit]. 

But I found another solution - I set a predefined filter and used the range-function. 

Kind regards,
Tina

------------------------------
Tina Noack
------------------------------

Original Message:
Sent: 03-15-2019 01:38 PM
From: HENK CAZEMIER
Subject: cast (...)

Hi Tina,
The following is a screen shot from FM, but RS has the same functionality.



In the example : to get a zero value interval day to second, you specify:
0 00:00:00.000000000 day to second

That will give a literal value that you can compare to columns of the same datatype.
// Henk


------------------------------
HENK CAZEMIER

Original Message:
Sent: 03-15-2019 12:03 PM
From: Tina Noack
Subject: cast (...)

Hi,

I'd like to cast a column of datatype " IntervalDayTimeValue" ([fällig seit]) to integer (smallint). So I did the following:
​
As you can see, the Syntax Editor does not throw any error.
But when I want to run the Report, the following error appears:


If I do something like cast(1,0; smallint) --> everything is fine

Furthermore, I tried the other way round: cast (0; intervalday) (I want to cast the Zero into Interval-datatype that I can compare them)
--> in this case, I'm not sure about the Syntax because the explanation for the function says that you have to add the type of Interval - but how ? I tried: interval_day,  intervalday etc. but nothing works.

I'd be glad if anyone can help.

Thanks in advance,
Tina




------------------------------
Tina
------------------------------

#CognosAnalyticswithWatson