IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

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: 7311
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 View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DFSORT/ICETOOL

 


Similar Topics
Topic Forum Replies
No new posts Modify Several JCLs at the Same Time JCL & VSAM 6
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
Search our Forums:

Back to Top