2 Replies Latest reply on Apr 10, 2017 7:12 PM by aldosilva6

    Date difference in Oracle BAM

    aldosilva6

      Hi guys,

       

      Does anybody knows how to caculate the number of days, hours, minutes and seconds in a field in Oracle BAM?

       

      I have created a calculated field but I can only use hour, minutes and seconds, it's not what I want.

       

      The function that I used:

      DATEDIFF(SQL_TSI_MINUTE,{Activity Start Time},{Activity End Time})