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

["John Taylor" <john.taylor@xxxxxxxxxxxxxxx>]

You can still create an RPG IV "utility" program that accepts the times as input parameters and calculates the difference for you. Then call this utility program dynamically from your RPG/400 program(s).

 

It would help if you could be a bit more specific for us. Do you need to calculate elapsed time across date boundaries, or is it always for a single day?

 

Within which environment do you need to perform these calculations (ie: RPG/400.. RPG IV.. CL... Query.. etc.)?

 

To what precision would you like the elapsed time returned as? Hours/Min/Seconds or rounded off?

 

 

Regards,

 

John Taylor

Canada

----- Original Message -----

From: sgt.walsh@icdc.com

To: MIDRANGE-L@midrange.com

Sent: Friday, July 14, 2000 07:33

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

The application is "RPG 400" (according to programmer at the vendor), not RPG IV.

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

sgt.walsh@icdc.com Sent by: owner-midrange-l@midrange.com 07/14/00 06:56 AM Please respond to MIDRANGE-L

To:        MIDRANGE-L@midrange.com         cc:                 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