Displaying lastruntime

• Jaseem Khan

  Newbie

  Points: 2

  More actions

  April 15, 2005 at 9:01 am

  #76283

  Hi,

  I am trying to display the lastruntime from the systasks table in a meaningful way. Curently it displays as 20000 for 2am, 4500 for 12:45am etc.

  Is there a function or a way to display the values in an easy to understand way - i.e. HH:MM:SS or similar format?

  TIA.

  JK.

• Jaseem Khan

  Newbie

  Points: 2

  More actions

  April 15, 2005 at 10:04 am

  #552950

  I have worked this out using the CASE construct and many SUBSTRINGS...

  Would appreciate a more efficient method if poss...

  JK.