RE: Query........Manipulating TimeFields

[Bill Erhardt <ERHARDT@xxxxxxxxxxxxx>]

Assumption #1 - You are using RPG IV
Assumption #2 - You have the time event dates (you will need these if event
one happened before mid night and event two happened after mid night).
If both assumptions are true, then you can build time stamp fields and use
the SUBDUR op code to calculate the duration.
 high_stamp        SUBDUR      Low_Stamp         Result:*S 
This will yield the number of seconds between the two time stamps.  You can
use *MN for minutes between the events and *H for hours.  
This information was gleaned from the RPG IV reference from IBM's Info
Center.
If you are not using RPG IV, then good luck, because this type of processing
gets to look real ugly.
Bill Erhardt
Baldwin Hardware
Reading PA

> -----Original Message-----
> From: sgt.walsh@icdc.com [SMTP:sgt.walsh@icdc.com]
> Sent: Friday, July 14, 2000 6:56 AM
> To:   MIDRANGE-L@midrange.com
> Subject:      Query........Manipulating TimeFields
> 
> Could someone please point me to some reference material on how to work 
> with fields containing time stored as a numeric (len6, dec 0.) 
> Specifically, I need to calculate elapsed time between twor or more time 
> fields.  Seems to me I need to create a Result Field but am not certain of
> 
> the correct formula to to the calculations between time1 and time 2 to get
> 
> Elapsed_Time. 
> 
> Sergeant John P. Walsh
> Haverford Township Police Department
> 1010 Darby Road
> Havertown, PA 19083
> Voice   610.853.1298 ext 212
> Fax      610.853.9210
> sgt_walsh@icdc.com << File: ATT04338.txt >>  << File: Message Body >> 


+---
| 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
+---