IBM Business Analytics

 View Only

  • 1.  how to get seconde difference between 2 datetime value

    Posted 04/26/23 03:31 AM

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




    ------------------------------
    Rodger Yang
    ------------------------------


  • 2.  RE: how to get seconde difference between 2 datetime value

    Posted 04/27/23 04:38 AM
    Edited by Patrick Neveu 04/27/23 04:57 AM

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



  • 3.  RE: how to get seconde difference between 2 datetime value

    Posted 04/28/23 07:12 AM

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



    ------------------------------
    NIGEL CAMPBELL
    ------------------------------



Related Content