IBM Business Analytics

how to get seconde difference between 2 datetime value。

for example in SQL SERVER script  like below,  in IBM Cognos Analytics , how to fullfill this request. 

DATEDIFF(SS,'2023.04.26 12:21:15','2022.04.26 12:21:10')

Hi Rodger,

If your database is SQL Server, you will create a query calculation in Report and add the following expression:

datediff({ss};2023-04-26 12:21:15;2023-04-26 12:21:10)

You might want to exchange date_expression1 and date_expression2 in datediff ( {datepart} , date_expression1 , date_expression2 ) in order to have a positive value.

If your database is NOT SQL Server, you just need to use the following expression:

_seconds_between(2023-04-26 12:21:25;2023-04-26 12:21:20)

(Edited to add _seconds_between)

Best regards,

------------------------------
Patrick Neveu
Positive Thinking Company
IBM Champion
------------------------------

use the _seconds_between expression, which will be generated using an equivalent vendor specific expression.