2 Replies Latest reply on Sep 4, 2018 9:36 PM by Tushar More

    time diff in seconds

    Jagadeesh Kumar Yogamoorthy

      Hi All,
      I need help in finding out difference between two time fields,
      Field name & Datatypes below are source from Db2.


      END _TiME (Timestamp)
      ETA  (Time)


      attache the  sample data.


      P:S:  need assistance in calculating the time diff in seconds with respect to AM/PM consideration




      Shinichiro Murakami