When subtracting 2 timestamps (Oracle dates) I want to format the outcome in minutes , but without having the unit 'minutes' displayed in reporting tools.
Is this possible (or do I need to code it with native functions?)
Turns out the customer wanted to have the numeric output for saving as Excel. So we coded it as an Oracle expression.
I'm really impressed with all the pre-formatting that Cognos provides, but sure wish to know how to crack this by a Cognos native solution..
Hello :)
I don't understand how the pattern works either for a time interval. I tried putting in HH:mm into the pattern property, but I got HH:mmHH:mm303059 milliseconds :o
The final format should be mm before the unit abbreviation 'm' instead of 'minutes'. So I reset and defined the Time unit to Minutes, i got 5 minutes.
Rest again and I defined the Time unit to Time, Display minutes to Yes, Display Milliseconds to No, i got here 05 ???
Anyone could help us ?
Thx ;)