duration time type in hh:mm:ss?!

[perspolis09]

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?

[CognosPaul]

'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]

[perspolis09]

thanks for the tip but it did not quite work :(

[CognosPaul]

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?

[perspolis09]

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.

[Dineshkumar]

Hi,

Follow the below steps, that will resolve ur problem.

1) cast(dataitme, interval second)
2) Properties -- see attachment..

-Dinesh

[perspolis09]

thank you Dineshkumar!