Print Page - Difference between Timestamp

Title: Difference between Timestamp
Post by: dri on 22 Apr 2016 02:27:18 PM

I need to get difference between two timestamp in minutes like (1.43). It should not display minutes or secs in output.

start: 01/24/2015 08:57:27 PM
end: 01/24/2015 08:58:53 PM

Output: 1.43

Please help.

Title: Re: Difference between Timestamp
Post by: dri on 22 Apr 2016 03:08:48 PM

Got it!

Title: Re: Difference between Timestamp
Post by: Raghuvir on 09 Aug 2017 12:51:18 AM

Quote from: dri on 22 Apr 2016 03:08:48 PM
Got it!

would be of great help if you could post the solution.

Thanks in advance!

Title: Re: Difference between Timestamp
Post by: chinnucognos on 10 Aug 2017 08:18:29 AM

Try this,

extract(minute,<date_exp1>) - extract(minute,<dat_exp2>)

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: dri on 22 Apr 2016 02:27:18 PM