title: Differnce between timestamp in db2 in time formate like hh:mm:ss
body: <p><strong>Below is query working in fine mysql databases</strong>.
  mysql> select REQ_NO,Req_CloseDate,Req_WorkStartDate,TIMEDIFF(Req_CloseDate,Req_WorkStartDate) Duration from Request_Master_Table where REQ_NO ='10348';
  +--------+---------------------+---------------------+----------+
  | REQ_NO | Req_CloseDate       | Req_WorkStartDate   | Duration |
  +--------+---------------------+---------------------+----------+
  |  10348 | 2017-02-03 05:36:14 | 2017-02-01 05:55:29 | 47:40:45 |
  +--------+---------------------+---------------------+----------+</p>
  
  <p>But I am not able to get in db2 what will be the query in db2 for getting the same output ?</p>