Hi,
i the below filter public I dropped the start time and the end time but in report its should look like "HH: MM: SS 'what's this Filter at the moment it give a '00 Hours', how can i modify or should add change?
(extract (hour, [Business]. [Use Deviation]. [END_TIMESTAMP]) * 60 + extract (minute, [Business]. [Use Deviation]. [END_TIMESTAMP])) - (extract (hour, [Business]. [use Deviation]. [START_TIMESTAMP]) * 60 + extract (minute, [Business]. [Use Deviation]. [START_TIMESTAMP])) + _days_between ([Business]. [Use Deviation]. [START_TIMESTAMP] [Business]. [Deviation use]. [END_TIMESTAMP]) * 1440
any idea?
'00 Hours' is an interval. You can format intervals by settings the data format to Time Interval. Time Unit --> Time. Display Hours Minutes and Seconds.
Your screen capture is showing a list of simple numbers. You can convert those into an interval by doing (1 hour) * [Data Item]
thanks for the tip but it did not quite work :(
I can only give you as much help as detail you give me.
Things to post: Version of Cognos, type of database you're using, error messages received (if any), exact output received, exact output expected.
The description that you gave is a bit difficult to understand, are you trying to filter the query by a specific duration, or do you want to see the duration in the list in time format?
Hi PaulM!
of course they i can send information :) I did not gate any error but interval time modify not help, i send attachment please check.
Hi,
Follow the below steps, that will resolve ur problem.
1) cast(dataitme, interval second)
2) Properties -- see attachment..
-Dinesh
thank you Dineshkumar!