Re: Query........Manipulating TimeFields

["Charly Jones" <charly301@xxxxxxxxxxx>]

>From: Larry Bolhuis <lbolhuis@arbsol.com>
>
>Seems like you hit on a pretty simple solution to me.
>
>One question though. Can you get the result back to Hrs/Mins/Secs in
>Query? I think that's tougher!
>
>  - Larry
>

When I was answering the question, I thought the issue was RPG III
versus RPG IV.  I was ranting against the advice that was being
given that in order to solve the problem, Sergeant Walsh was going
to have to recognize the fact that RPG III is dead and he and his
software provider were going to --HAVE-- to upgrade their tools
to the latest and greatest language, RPG IV...

Using either RPG III or RPG IV, the conversion back to
hours/minutes/seconds is pretty trivial, using
divide and "move remainder" ...

Using Query doesn't seem so tough either:

      hours   =  elapsed.seconds/3600  (drop the remainder)
      minutes = (elapsed.seconds - (hours * 3600))/60
      seconds = (elapsed.seconds - (hours * 3600)) - (minutes * 60)

Charly Jones

Curator of the IBM GSD Museum
"Geezer in Gig Harbor"





________________________________________________________________________
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com

+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---