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

    Date difference in Oracle BAM


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