If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Difference between Timestamp

Started by dri, 22 Apr 2016 02:27:18 PM

Previous topic - Next topic

dri

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.


Raghuvir

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!

chinnucognos

Try this,

extract(minute,<date_exp1>) - extract(minute,<dat_exp2>)
Deal with it!