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