Portal | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Forum Index
 
Register
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
Is there a time Version of DATEDIFF ?

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DFSORT/ICETOOL
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    Post subject: Is there a time Version of DATEDIFF ?
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    Post subject: Reply to: Is there a time Version of DATEDIFF ?
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    IBMMAINFRAMES.com Support Forums -> DFSORT/ICETOOL All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts How to process dependent file based o... HithaSri JCL & VSAM 8 Sun Sep 06, 2020 12:42 pm
No new posts reffering the filename with date and ... skbk JCL & VSAM 9 Sat Jun 06, 2020 4:57 pm
No new posts Mainframes Job opportunity-Full time Rohit Umarjikar Mainframe Jobs 0 Tue Nov 19, 2019 7:48 am
This topic is locked: you cannot edit posts or make replies. COBOL/CICS with real time MQ Series u... BPranav CICS 2 Mon Sep 16, 2019 9:19 pm
No new posts z/VM z/VSE Get CPU-time of a COBOL Ba... Andi1982 COBOL Programming 3 Mon Mar 11, 2019 3:36 pm

Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us