title: How can I convert microseconds to H:MM:SS.mmmmmm in DB2/z
body: <p>Using DB2 on the mainframe, I have a value indicating number of microseconds that a job took, say <code>26,366,861,945</code>.</p>
  
  <p>Is there any easy way to get that into the <code>H:MM:SS.mmmmmm</code> format using standard DB2 functions? In other words, that value above would become <code>7:19:26.861945</code>.</p>
  
  <p>If necessary, we can drop the microseconds and accept <code>HH:MM:SS</code>.</p>
  
  <p>If it's over 24 hours, I'm not fussed about showing days, <code>27:02:14</code> would be fine.</p>
  
  <p>I though about selecting the zero time <code>plus xx microseconds</code> but couldn't get it to work.</p>