IBM Mainframe Forum Index
 
Register
 
IBM Mainframe Forum Index Mainframe: Search Log in to check your private messages Log in
 

Is there a time Version of DATEDIFF ?


 
IBM Mainframe Forums -> DFSORT/ICETOOL
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
Steve Ironmonger

New User


Joined: 19 Oct 2015
Posts: 15
Location: UK

PostPosted: Wed Aug 17, 2016 7:06 pm
Reply with quote

Just wondering if this is possible.

I'm trying to calculate the difference between two times (i've created the times in a REXX so I can format them any way I want)

Basically my data looks like this

Code:

Cust Num,Date,Start Time,End Time
000000426,20160802,16:54:30,0009,17:02:28


I want to calculate the difference between the 2 times and create a file that contains the following :-

Code:

Cust Num,Date,Start Time,End Time
000000426,20160802,16:54:30,0009,17:02:28,00:07:58


I.e. the difference between the end time and the start time

I can do what I want in excel or in the rexx, I'd rather not do it in the rexx as the job is going to run daily and there will be several 100,000 records to process and I don't want capacity & performance on my back about how much CPU my job is using !

Any help or ideas would be greatly appreciated.
Back to top
View user's profile Send private message
Bill Woodger

Moderator Emeritus


Joined: 09 Mar 2011
Posts: 7312
Location: Inside the Matrix

PostPosted: Wed Aug 17, 2016 10:45 pm
Reply with quote

No end date? Jobs running for longer than 24 hours will be incorrect.

Jobs starting before midnight, ending after midnight complicate things. Identical start and end times could occur? Would they be less than one second, or exactly 24 hours?

If you can do seconds since midnight in your Rexx, it would make things easier. You'd still have some calculation to get hours and minutes.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic All times are GMT + 6 Hours
Forum Index -> DFSORT/ICETOOL
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Forum Replies
No new posts How to process dependent file based o... JCL & VSAM 8
No new posts reffering the filename with date and ... JCL & VSAM 9
No new posts Mainframes Job opportunity-Full time Mainframe Jobs 0
This topic is locked: you cannot edit posts or make replies. COBOL/CICS with real time MQ Series u... CICS 2
No new posts z/VM z/VSE Get CPU-time of a COBOL Ba... COBOL Programming 3

Back to Top